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!
Thank you!
Best Answer
-
It sounds like you've done most of the hard work already!
Since you have a column that identifies the date, you could set up a Report which filters by this date column to only show the past 52 weeks or 365 days, as well as only pulling in rows that have the totals in the Weekly Total Column.
You could then even use the Summary function to SUM together all of your weekly totals for an overall total. Here's more information on creating a Report, and Webinar on Reports, too.
Cheers,
Genevieve
Answers
-
It sounds like you've done most of the hard work already!
Since you have a column that identifies the date, you could set up a Report which filters by this date column to only show the past 52 weeks or 365 days, as well as only pulling in rows that have the totals in the Weekly Total Column.
You could then even use the Summary function to SUM together all of your weekly totals for an overall total. Here's more information on creating a Report, and Webinar on Reports, too.
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!