Conditional Formatting with multi select dropdown list
When using Conditional Formatting, I want to make my primary column change colors when a combination of choices are made in a multi select dropdown,.
What it looks like now is this: If column 2 is 'condition' and column 3 contains 'condition one' or 'condition two' then apply this format to the column one
Is there a way to change it to column 3 contains 'condition one' AND 'condition two' ?
Thanks for any help you can give
Comments
-
Hi,
Yes, If you click on the menu opener (down arrow) in the left on the rule you have, you can select AND.
Did it work?
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Why can't you apply conditional formatting to a multi-select column type when it has more than one of the drop-down items selected?
It seems like this functionality should be there as the formatting builder is looking to see whether or not the cell contains either "A" or "B" or "C" (so on and so forth).
Has anyone else noticed this yet?
-
Update**
I was able to get a slight workaround to work by clicking "define custom criteria" and typing in the same values that I would have otherwise checked in the list... I don't know why it works one way and not the other, but I was at least able to get it to work.
-
Hi Alex,
Great idea! I agree it should be possible to use the same as a dropdown list.
Please submit an Enhancement Request when you have a moment.
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives