Recommended workflow for testing/updating in one sheet and then moving updates to Live sheet

Jeana
Jeana ✭✭✭✭✭✭

Here's my current workflow and I know there must be a better way.

I have a TEST Smartsheet that matches a LIVE Smartsheet

In the TEST sheet I make requested modifications to columns and formulas. Once completed I am manually modifying the columns and formulas in the LIVE sheet to implement the changes. This is way to time consuming and prone to human error. A lot of copying and pasting.

What is a better method to implement changes in the TEST sheet into the LIVE sheet and keep the data in the LIVE sheet?

Thanks,

Jeana

Answers