Move Row Automation Not Working - Rows Missing

Kelly Pratt

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.

Andrée Starå

@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å

Hi @Kelly Pratt

I hope you're well and safe!

• If you look in the Activity Log on the Destination sheet, can you see that the row(s) were added?
• Have you looked at the bottom of the sheet?

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

✅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!

Kelly Pratt

Hi @Andrée Starå ! Thanks for your response. The destination sheet does say a row was added, but it's not there! I only have 5 rows added in the destination sheet so far, so I am looking at all of them :)

Andrée Starå

@Kelly Pratt

Happy to help!

Did you check at the bottom of the sheet?

Kelly Pratt

@Andrée Starå i didn’t know what you meant at first because I was looking at the bottom of the rows I already had in there. I scrolled… and now see them 🤦🏻‍♀️

why is that happening? Is there a way I can make the rows show at the top?

thank you!

Andrée Starå

@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!

Kelly Pratt

Yes! Thank you @Andrée Starå , now I'm getting it :)

Andrée Starå

@Kelly Pratt

👍️ I'm always happy to help!

✅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!