Color coding in calendar view - How can you change the auto color which seems to be set at "health"
I would like to color code the calendar view by a different column. It seems default is health (red, yellow, green) but I want it to be set by a custom column I have set up for the category.
Best Answer
-
Then check if there isn't some conditional formatting to deactivate or remove.
Answers
-
Hi @Paige Luben
You can do that in the conditional formatting menu.
Simply select the color of the task bar (the option at the very bottom) that you wish to display for the row.
https://help.smartsheet.com/sites/default/files/inline-images/Formatting%20Options.png
-
@David Joyeuse Thank you -- I actually tried that 😕 but it just turns right back to the color of the health column. I did not set up the sheet so I was thinking maybe there is some other setting that does some type of auto conditional formatting that was turned on.
-
Then check if there isn't some conditional formatting to deactivate or remove.
-
Hi @Paige Luben
To add to Davids excellent advice.
Also, have a look at the order of the Conditional Formatting rules. They are read from top to bottom.
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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!