Link Data in a Smartsheet on a Specific Day and Make Static
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!