Dashboard Widget to show completed items by month and year
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.
Answers
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives