color calendar in dashboard

Jillian Cadorette

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!

Humashankar

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

Humashankar

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

Jillian Cadorette

This helped, thank you @Humashankar