Calculating daily and last 30 days averages based on form submissions
I am collecting daily form submissions and want to have a dashboard to report on key metrics from these submissions. See screenshot.
Here's what I want to calculate:
- Daily average for columns Role, Identity, Technique, Quality of Day, and My Score Today. At the end of the day I need to see what TODAY's average number is for each of those columns, using only data collected on today's date.
- 30-day rolling average for each of the above mentioned columns.
I'm guessing I need to calculate this in the cells above, to be able to put onto a dashboard with a barometer type widget.
Can anyone help with the correct formula to display these numbers please? Can I then push these numbers through to a Smartsheet dashboard?
Help Article Resources
Check out the Formula Handbook template!