0

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")

Improve this question

2 Answers 2

Reset to default
0

Extending your current formula slightly should do the trick:

=IF(ISNUMBER(FIND("Urgent",Content)),"Yes",IF(ISNUMBER(FIND("Date",Content)),"Yes","No")
Improve this answer
0

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

Improve this answer

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.