What if I need a "contains" command instead of an
=IF([Package Status]="Further Clarification","Yes","No")
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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.