Weekly Sum for Rolling 1 year (52 weeks)
I have a smartsheet grid that tracks the number of units sold each day - every day is a different row.
Every Monday, it sums the number of units sold for the past week. For example, on Monday 10/18 it will sum the total number of units sold between Monday 10/11 - Sunday 10/17. This is displayed in a weekly total column (only every seventh row, on Mondays)
Currently the sheet has data from the beginning of 2020 through today. It is displayed in a dashboard using a widget to pull in the weekly total and the data label - the chart is very crowded with over a year and a half of data.
My manager would like to see the weekly total with rolling 1 year of data (52 weeks). I'm at a loss for how to set this up - please help!
Help Article Resources
Check out the Formula Handbook template!