Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Copy a set of sheet that have links
I have created a set of sheets that I will use to managed various parts of a Project. Between the sheets, I've linked a number of cells, pulling data from one sheet to another.
As I'm going to run this type of project many times, I need to copy this set and reuse them for another project.
I can copy the sheets, but the links are still referencing the original set.
Is there a way to copy the set and keep the links referring to the sheets in the copied set?
For example -
Set 1 has a Sheet called Project 1 Schedule. The dates from the schedule are linked to another sheet Project 1 Site Data.
Can I copy these sheets and keep the links from Copy of Project 1 Schedule to Copy of Project 1 Site Data?
I don't want to recreate the links every time I start an new Project.