Dashboard Widget to show completed items by month and year

Dom Yap

Hi all,

I am trying to complete a dashboard item that was started by a colleague and starting to wonder if this is even able to be accomplished. Below are screenshots of what I am trying to achieve.

I am grabbing a column from a sheet and want to display it on a dashboard widget.

Austin Smith

@Dom Yap

Easiest thing to do imo:

Make a helper column called Month with column formula =month([Actual Completion Date]@row)

Build out another sheet, or use summary data if you won't modify it much. =countif(Month:Month, month reference) then run a report on that column if you didn't build a separate sheet.

Then pull a chart on the summary data sheet/report. Should give you a clean, live data bar chart.

I have a general collector summary data sheet that I use for this exact purpose and it generates a lot of the charts that we use.