Move Row Automation Not Working - Rows Missing

I have a move row automation in place that is causing my data to go missing. The activity history shows that the automation is working and the rows are moving, but they never show on the destination sheet. (Yes, I have verified I am looking at the right destination sheet).

The source sheet and destination sheet have the exact same columns, so I am not sure what the issue is?

Any help/insight would be appreciated! Thank you.

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    @Kelly Pratt

    Easy to miss!

    It's happening because the rows above are not empty (even if they might look like they are).

    You'd need to delete the rows between the rows that you want to keep. You must delete the rows and not only the contents.

    Make sense?

    Did that work?

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.