What if I need a "contains" command instead of an
=IF([Package Status]="Further Clarification","Yes","No")
You could try the FIND formula for this one.
e.g. Check if "ABC" contains "A"
For more details, check out this link.
I have edited your given formula to get the desired result:
=IF(ISERROR(FIND("Further Clarification",[Package Status])),"No","Yes")
Explanation: Above formula will first find the "Further Clarification" in the column called "Package Status". If this find results in an error (that is, the String is not in the column/data does not exist) it will return "No". Otherwise, the String exists in the column, so it returns "Yes".
Ask me for further information.