Use relative links between sheets restricted to a single workspace
Hi,
I have 1 sheet (sheet1) that takes a value into another one (sheet2). I would like the link between both to be relative and restricted to a single workspace so when I copy both in a new workspace (w2), they remain linked to each other but can't access original workspace (w1). Result would be sheet1w2 linked to sheet2w2
Curently, it is doing sheet1w2 linked to sheet2w1
Thanks a lot
Answers
-
Hi @B_Bernard_D,
If you are trying to copy each sheet individually and move them into a new workspace then the links will be absolute instead of relative.
However, if you duplicate the entire workspace or folder then the new copied sheets will be relative to each other.
Is it possible for you to put sheet1 and sheet2 into their own workspace, and then copy that workspace whenever you want to copy the sheets?
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!