How to Record Data Weekly


I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed.

Is there any way to record the data weekly?

so I'll have last week Friday, 2 weeks 3 weeks and 4 weeks ago Friday,

Thank you! 😀


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!