Avrage last 6 months

Options

Hi

I'm trying to get a rolling average but cant seam to get anything to work.

my data columns are Date, Total In, Av Last 6m

Id like the Av Last 6m to average the last 6months of entries in the total in according to the date column

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!