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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!