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

  • Humashankar
    Humashankar ✭✭✭✭✭
    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


    Community Leader