color calendar in dashboard

Options

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 ✓
    Options

    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

Answers