Conditional formatting an entire sheet?
I'm looking to set up a workplace roster on Smartsheet, to cover the 50-odd employees in our workshop.
- each employee has their own column
- date tracks row by row
- each cell tracks daily rostered hours for each employee
I already have something of this sort set up, but I want to develop it an extra step or two so it will be suitable for the whole office to use. I want to highlight cells a different colour if they contain information other than working hours - AL (annual leave), RDO (rostered day off), PH (public holiday), TRN (training), Sick.... etc.
If I set up the conditional formatting rules as I understand them, I will need to generate hundreds of rules to cover the workforce, and this is not practical.
My question - Can conditional formatting rules be created that apply to an entire sheet?
Answers
-
I hope you're well and safe!
Unfortunately, it's not possible now to set the Conditional Formatting for the sheet, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Have a fantastic week & Happy New Year!
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!
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
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!