color calendar in dashboard

Jillian Cadorette

Jillian Cadorette ✭✭✭

03/29/24 in Smartsheet Basics

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!

1 ·

Best Answer

Humashankar ✭✭✭✭✭

03/29/24 Answer ✓

Hi @Jillian Cadorette
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
0 · Share on Facebook Share on Twitter

Answers

Humashankar ✭✭✭✭✭

03/29/24 Answer ✓

Hi @Jillian Cadorette
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
0 · Share on Facebook Share on Twitter
Jillian Cadorette ✭✭✭

04/09/24

This helped, thank you @Humashankar

1 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Workaround for triggering generate document workflow when any of the 380 fields I have change
I need a generate document workflow to run anytime one of them changes. I don't want to put in all 380 fields, I don't even know if it will let me add that many. It seem as if the "if any field changes" option is not available on the generate documents workflow, you have to select at least one field.
How to automatically include project names in automated update requests and forms
Hi, I have several projects that follow the same breakdown structure, when Smartsheet sends automated update requests, users are receiving these notifications don't know which specific project the request is referring to. I noticed that the project name is not an automatically included in all update requests for different…
Can you create multiple workflows if you have too many actions for one?
Hoping this is an easy question. If you have an automation workflow that reaches the limit of blocks (too many actions), can you build a second workflow to pick up where you left off, or will that interfere with the first flow? My example is Condition path 1 - if state=X, request an approval from StateX email contact, if…

Help shape the future of Smartsheet.
Share your ideas and feature requests.