Automation or Conditional Formatting
Hi Team
How do I place a conditional rule for a scenario on a column where I have a drop down setup for Multi Select with values '1', '2', '3' and 'A'.
The condition should highlight the cell if the user selects 'A' along with any other ('1', '2' or '3')
This is to remind user to remove the 'A' if they have picked '1', '2' or '3' and their combinations
No color reminder required for Just selecting 'A'
Please suggest
Answers
-
For a Multi-Select column, you can use the Conditional Formatting option "If <column> contains 'A' then apply this format to the entire row (or specific columns).
-
Hi, But the condition should work only if "A" has been selected in Tandem to 1/2/3 or their combinations.
-
Ok, I used a helper column to make this happen.
Column 1 has a Multi-Select option of 1, 2, 3, A
Column 2 has a Column Formula equal to that of the previous column
Conditional Formatting is as follows:
- If <column 1> contains '1' or '2' or '3' and <column 2> contains 'A' then apply this format to the entire row (or specific rows).
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives