Automation: Copy Row to Another Sheet

With automation, I am able to copy rows from one sheet to another based on certain criteria. When this happens, the rows are added to the bottom of the destination sheet. Is it possible to place the rows in a certain place within the document, without manually moving?

The goal is to copy 4-5 tasks that need to repeat several times within the sheet, but need to be placed under the correct parent.



  • James Keuning
    James Keuning ✭✭✭✭✭

    That would be awesome but no, it cannot be done. It's a pretty major limitation of the parent/child hierarchy. We encounter this problem in other areas, for example, a form where we want an entry to be added into a specified hierarchy.

    When we face this problem we just flatten everything out and put the hierarchy information in columns.

    If Smartsheet ever fixes this in these use-cases, we will come back the same day and ask them to do Data Shuttle now (let me shuttle data into specific hierarchies)

  • DoraExplorer
    DoraExplorer ✭✭
    edited 11/03/23

    Thanks @James Keuning. I love and hate Smartsheet at the same time. 😁