Move Row Automation with Child Tasks
I'm using a sheet to track all projects for this year (Parent), their major tasks (child), and then the subtasks (child of task). Each row has a checkbox to click when completed. I want to set up a Move Rows automation for when the project is checked complete, that parent row & all its child rows get moved to a sheet for completed projects.
When I tried to set it up I could only get the parent row to move, leaving all the child rows behind and messing up my sheet. Is there an easy way to do this?
Thanks in advance for any advice.