Formula help recognising multiple words

dave.mcpherson56751
dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi,

I have a formula that looks for a specific word or variance of the word, is it possible to look for more than one word?

The formula i have is =COUNTIFS(Response1, FIND("shower", LOWER(@cell)) > 0)

This works for the word showers or shower which is perfect, however am i am able to count if the cell contains either "shower" or "Clean"

Appreciate any help or guidance.

As always thank you in advance

Dave

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!