How to use if contains with similar words


I want to use if contains to find a word and classify it

The problem I have is they are to similar it will always Classify it as A and not B.

the description is to long for Has or just a regular if Statement.

=IF(CONTAINS("EOR", description@row), "A", IF(CONTAINS("BOR", description@row), "A", IF(CONTAINS("CBOR", description@row), "B", IF(CONTAINS("CEOR", description@row), "B"))))

or similar if you had to classify apple as group A and Apples as group B


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!