Linking smartsheet

JamieRox

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. 

Andrée Starå

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