Create a running average cell in a sheet.

SGreenfield

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

AnthroTim

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