End of Year Rollover

Good afternoon,

I have been given the task to do a year end rollover. This has me duplicating each sheet, but then having to go in and change formulas for the additional sheets I'm creating. This is a very time consuming task, and I'm sure there has to be an easier way. After googling and trial and error, I have yet to figure it out. Does anyone have a better solution?

Thanks in advance!



  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Kris Guthier

    Hope you are fine, did you try to save your original sheet which contain your formula as a template

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!