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!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!