How to link a row with children to another sheet
So I figured out how to link cells between sheets, but my source sheet has a structure 2-3 levels deep (rows with children). If I try to link the entire sheet it shows up at destination sheet but the structure is flattened.
Best Answer
-
You are going to have to manually indent each row where needed. There is no way to automatically indent rows without the help of the API or Bridge add-on.
Answers
-
You are going to have to manually indent each row where needed. There is no way to automatically indent rows without the help of the API or Bridge add-on.
-
Thanks Paul. I figured out a workaround by only linking the top-level row and providing a hyperlink back to the source sheet if anyone wants to view the structure tree
-
Happy to help. 👍️
I understand why they don't enforce the indentation through cell linking, but I do see your use case. Maybe they could make it an option when creating the cell link?
Definitely take a look through the Ideas topic. If someone has already submitted it as an idea then you can vote for it. If they haven't then you can submit it yourself and allow others to vote on it. This lets Smartsheet know there is some interest in this feature being implemented.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!