How can you combine a date and status field to create a colored date field on a heat map? Advice welcome

[ShelleyDonovan (Shelley Donovan Ritchie)]

How can you combine a date and status field to create a colored date field on a heat map? Advice welcome.

[Clarey (MondayMotivator)]

Hi Shelly, as far as I am aware you can’t make a single “colored date” column, but you can combine Date + Status for a heat map using views/widgets.

Two easy ways:

1. Calendar heat map (by item color)

• Set your Status as the item color: Status column menu → Set as item default color.

• Add a Calendar view or Calendar widget → enable Heatmap (shades by volume) and “Use item color.”

• Filter by Status if you want a heat map per status.

2. Dashboard Chart heat map (date bucket × status)

• Add a Formula column to bucket the date, e.g.:

  • Month: FORMAT_DATE({Date},“YYYY-MM”)

  • Week: “W” & WEEKNUM({Date})

• Add a Chart widget → Heatmap

  • X axis: your Month/Week formula

  • Y axis: Status

  • Value: Count of items
    This shows intensity by how many items of each status fall in each time bucket.

Notes:

• Date cells themselves can’t be conditionally colored.

• Formula columns can’t become Date-type columns

[cherzog (Christina Herzog)]

This sounds exciting! I didn’t realize there were heat map capabilities. Can you please provide more information on the Status column (how to set as item default color) and how to enable the Heatmap in a Calendar View. Thanks!

[Clarey (MondayMotivator)]

Hey, Sure please see in the status column how to edit the colours / set the default:

The pivot table works well for numbers etc then on calendar just add the Status / heat map colours to be shown!