How to automatically move Parent & Child tasks to new sheet
I love the automation to move rows to an archive sheet once completed. Is there a way to move the parent and child projects together? This would only occur once all child project have been completed.
Best Answer
-
Yes. You could put in a formula that checks to see if a parent row has, for example, a box checked that would cause it to be moved to a new sheet and check it's box that causes it to also be moved to a new sheet. However, the child rows will be moved to the new sheet and will become parent rows. There isn't currently a way to move them all with the same parent/child structure they have on the original sheet. You'll need to submit an Enhancement Request for that type of functionality.
Answers
-
Yes. You could put in a formula that checks to see if a parent row has, for example, a box checked that would cause it to be moved to a new sheet and check it's box that causes it to also be moved to a new sheet. However, the child rows will be moved to the new sheet and will become parent rows. There isn't currently a way to move them all with the same parent/child structure they have on the original sheet. You'll need to submit an Enhancement Request for that type of functionality.
