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.
Comments
-
Hi Allan! Yes this is possible. Add all the sheets you want to copy to a folder or workspace on your Home tab. Then right click on the folder/workspace and select Save as New. By default, it will keep all the links relative to the newly created sheets.
-
I have a workspace that needs to be updated from a workspace created with new data. When I remove the sheets from the workspace then re-add them from another workspace as save by new, then links do not get copied over. I have to go and manually update each one. Example I have a set of Folders in the new workspace with Sheets, dashboard etc, then I copy the entire folder set and save as new to Orig workspace, the links stay in the new workspace and not the orginal. However if I save as new the whole workspace then the links are good. It doesn't work on an existing workspace. Is there a way around this?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- New program proposals are submitted via a form and collected on Sheet 1. When approved by a team leader, the row is copied to Sheet 2. I want to capture the date the copied occurred, which I thought w…
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…