Any ideas on an easy way to capture data on a rolling monthly basis and show on a dashboard


We are capturing different types of statistics for multiple different subject areas every month and need to:

a) easily get people to update the data

b) easily show it on a Dashboard

I've tried multiple different ways of sheet design but I keep coming up again blocks - ie either data can't be shown in a graph or the workaround causes a lot of effort linking sheets at the end of each month.

If anyone has any ideas on the best way to report via a dashboard on rolling monthly data, I would be eternally grateful!

Here is what I've tried so far…

1. Vertical Month/Horizontal Subject/Status in Cell

2. Vertical Subject/Horizontal Month/Status in Cell

3. Filled in via Form adding each subject, month, year, status - row per subject for each month.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!