Conditional Formatting When Multiple Values Are Selected

JennOliver

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.

Jason Duryea

With multi-value columns, you may need to try using CONTAINS, instead of EQUALS.

Jason Duryea

With multi-value columns, you may need to try using CONTAINS, instead of EQUALS.

JennOliver

That fixed it! Thank you!

Andrée Starå

Hi @JennOliver

I hope you're well and safe!

To add to Jason's excellent advice/answer.

• Beware that it will also be true if those two values and other values are selected simultaneously.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!