Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?
Hello!
I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports primarily.
So all of this comes from the same source sheets, but we're creating these different reports for specific use cases, and many of these reports we see together on a single dashboard.
How can we make it so that each calendar has its own color key? For example, on a master calendar view, we'd want to see the colors by project (so, by sheet). But on a resourcing calendar, we'd want to see the color by the Assigned To column.
I know the colors pull from the task bar in conditional formatting, but stuck on how we can apply different formats to different reports, from the same sheet?
Answers
-
Hi @chlod24
I hope you're well and safe!
The color can't change depending on which report it's shown in. It will always be the same for all.
Make sense?
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 support the Community by marking it Insightful/Vote Up, Awesome, 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.
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
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives