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


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
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Rachel Apodaca

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

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!