If all Child rows = "Complete" change Parent to "Complete" and send to new sheet

clairehunter

Hello!

I have an automation that sends "Complete" Parent columns to a new sheet (my "Closed Orders" sheet). I also am setting up a formula for when all Children status' are set to "Complete" it automatically switches the Parent row to "Complete". What I am wanting to do is send ALL rows including Parent and its Children in the exact same formatting to my "Closed Orders" sheet. How would I go about doing this? Thanks so much!

Paul Newcome

The move row automation will move all children underneath of a parent row if just the parent row is what triggers the automation.

Paul Newcome

The move row automation will move all children underneath of a parent row if just the parent row is what triggers the automation.