I have a Single Line Text Column(Content). I would like to create a calculated column that returns "Yes" if the Content column contains either of the two words- "Urgent" or"Date".

I have only managed to create the formula that returns "Yes" if the column contains "Urgent". How do I find for either of the two words?

Current formula: =IF(ISNUMBER(FIND("Urgent",Content)),"Yes","No")

2 Answers 2


Extending your current formula slightly should do the trick:


You could also use an OR statement: =IF(OR(Content="Urgent",Content="Date"),"Yes","No")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.