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
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!