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.