Linking smartsheet

edited 12/09/19 in Formulas and Functions

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. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!