color calendar in dashboard
Hello! I would like to show daily trends in a calendar format on the dashboard, similar to this but just red/green. It would be based on conditional formating that I have in the sheet. It's okay if it isn't exactly in a calendar format, but I want to show the red/green trends over the current month. Thanks for any help!
Best Answer
-
Looks you already on it and only a few steps will help you to achieve this
Once after the Calendar View and after selecting the Calendar Format as Month
In the Calendar View, right-click on a date and select "Color Calendar"
Choose the formatted columns and set the colors (red/green)
Similar topic is already discussed in the community and here is the one for your reference.
Color coding calendars in smartsheet — Smartsheet Community
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Huma
Community Leader
Answers
-
Looks you already on it and only a few steps will help you to achieve this
Once after the Calendar View and after selecting the Calendar Format as Month
In the Calendar View, right-click on a date and select "Color Calendar"
Choose the formatted columns and set the colors (red/green)
Similar topic is already discussed in the community and here is the one for your reference.
Color coding calendars in smartsheet — Smartsheet Community
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
Huma
Community Leader
-
This helped, thank you @Humashankar
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives