Create a running average cell in a sheet.
I am wanting to build a KPI report so staff can see the running average of output for the team. Daily data will be collected through a form, so thinking of having a cell in the sheet that auto calculates the average date of a column over the past 30 days
Answers
-
Hi,
It sounds like you need to use the AVG function with a COLLECT function.
The AVG will give you the average, but you only need to collect the past 30days worth of entries.
Something like this, obviously your column names will be different :)
=AVG(COLLECT([OutputColumn]:[OutputColumn], [DateColumn]:[DateColumn], >=(TODAY()-30)))
See here for more info: https://help.smartsheet.com/function/avg
Good luck!
Tim
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!