Linking smartsheet

I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added.
1. When linking i lose child sheet hierarchy on the master sheet. How do i maintain hierarchy?
2. When new tasks are added (with hierarchy) how can i keep the master updated automatically?
3. Can i create hierarchy using a formula?
Thanks in advance.
Comments
-
Hi Jamie,
Unfortunately, it's not possible to maintain the hierarchy between sheets and there isn't a formula for hierarchy at the moment, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
Happy Holidays & Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!