Move data through a series of columns to show week over week changes

I have a column with the current week's data in it. This is pulled programmatically each week. I'd like to be able to move that data over to a new column each week before the api kicks in so I can compare week over week performance. So

Col A: Data from this week pulled in on Weds

Col B: Data from the previous week copied over via automation or formula

Col C: Data from 2 weeks ago

Col D: Data from 3 weeks ago

Col E: Data from 4 weeks ago

To complicate things further, I'd like for the data to be rolling. So the data from col E drops off each week and is replaced by the data from col D and so on.

Is this achievable?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!