Link Data in a Smartsheet on a Specific Day and Make Static

Donna T
Donna T ✭✭
edited 03/25/20 in Formulas and Functions

I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet.

I want to create a new Smartsheet that links data from the %Complete metric on a given day, and make that data static in the new Smartsheet. The goal is to run the report every 2 weeks , comparing the last % Complete that was recorded, to the new % Complete.

I understand how to link cells between sheets, but the data is dynamic and changes with modifications to the linked cells, so I can't record the status of the %Complete on a specific day.

Thanks for your help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!