Question about copying a sheet

Lindsay Megenhardt

I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet. Is there an easy way to change all calculations to pull from the new 2025 sheet without having to manually change each one?

kowal

hi @Lindsay Megenhardt,

when you cell link (or use formulas with range from different sheet) to other sheets they will stay like that forever.

You would need to make a new cell linking (or new ranges for formulas)

You can always create new sheet (archive) move all the rows at once over there (move rows) and start creating data in the same sheet (just rename it to 2025)

Hope this helps.

kowal

hi @Lindsay Megenhardt,

when you cell link (or use formulas with range from different sheet) to other sheets they will stay like that forever.

You would need to make a new cell linking (or new ranges for formulas)

You can always create new sheet (archive) move all the rows at once over there (move rows) and start creating data in the same sheet (just rename it to 2025)

Hope this helps.