Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formula to Calculate Rolling Average based on the current Week of the year
I have a Smartsheet that will have values inputted each week and I would like to calculate an historical rolling average based on the last four weeks. What formula would I use to calculate this rolling average?
Example data (Assuming current week is 201905)
4 Week Rolling Average 201901 201902 201903 201904 201905
=average of 201902 - 201905 10 5 4 5 3