Conditional formatting of task bar for 'Assigned to' containing two names not working
I have conditional formatting to give each person a different color on the task bar. Some tasks are assigned to more than one person, eg Mark and Fred. It's not working to format a different color for tasks assigned to Mark AND Fred.
Answers
-
Hi Mark,
At this time Conditional formatting is only able to look to see if a cell in a Contact column contains either this name or that name, but cannot read a combination of two names as one unique value. Therefore, if you have two names selected in one cell, the formatting will display whichever name is highest in your Conditional Formatting list (as that will be the first rule applied).
Please submit an Enhancement Request when you have a moment!
If the colour change is important, we could potentially include a Helper Column in your sheet which assigns a specific number to each possible combination of names selected. (Ex, "Mark & Fred" = 1, "Mark & John" = 2, "John & Fred" = 3... etc)
You could then have your Conditional Formatting rules be based on this helper column looking at the different numbers, in addition to looking at the names. If you only have a small number of names and possible combinations this could be a good solution, but if you have many possible combinations it could get a bit complicated. Let me know what you think!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 369 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 280 Events
- 31 Webinars
- 7.3K Forum Archives