Want to Save as New Sheet Connected to Dashboards and Reports w/o Relinking
I have a master Sheet that links to multiple Dashboards and scores of reports. Our 2023 exercise is done and now want to stand-up 2024; however, there seems to be an order of events to Save as New so I don't have to relink everything. Please advise if there is a best-practice for Saving as New with linked Dashboards and Reports.
Best Answer
-
Yes. You would drop all folders, dashboards, sheets, etc. that you want linked together into a single folder or workspace and then duplicate that.
Answers
-
If you drop everything into the same folder or workspace, you can "Save as New" that folder or workspace and select the option for links and whatnot to be connected to the newly created sheets etc..
-
Thank you, that's great. However, when I select the folder contents, the Actions button is greyed out:
-
My apologies, I see it now that I need to click the checkbox for the actual folder I want to duplicate. Thanks again!!
-
Yes. You would drop all folders, dashboards, sheets, etc. that you want linked together into a single folder or workspace and then duplicate that.
Help Article Resources
Categories
Check out the Formula Handbook template!
