Conditional Formatting When Multiple Values Are Selected
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.
Help Article Resources
Check out the Formula Handbook template!