How to keep parent rows source and destination sheets while keeping the nesting of the children?

Rachel Apodaca

I am managing two sheets for a project, one for an active project and another for archived tasks of the source project sheet. I have a workflow that moves the rows that meet the "archive" criteria, but I need the child rows that get moved to the destination sheet to organize under the proper parent rows when they are moved to the destination sheet vs organizing by when they are added o the destination sheet. Is there a formula I need to be using for this to happen on the source or destination sheet?

Bassam Khalil

Hi @Rachel Apodaca

Hope you are fine, unfortunately, this option isn't available now as i know.