Conditional Formatting When Multiple Values Are Selected

edited 02/03/22 in Formulas and Functions

I am having trouble getting our Smartsheet to apply conditional formatting if we have two values selected within the cell (see image).

Goal: If Geography has North America and EMEA and APAC selected, we want the cell to appear red. (having same issue if only two are selected also). Currently even with the rule in place, any of our items that have more than one Geography chosen are defaulting to light blue right now.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!