Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?

Sherry Fox

Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen.

The users enter the data from an Intake Form, it gets placed onto this sheet. They do not have access to alter this sheet.

Carson Penticuff

I would start by checking the activity log to see if there is anything related to those specific rows. You may also check the cell history for cells on those rows as well. I do occasionally end up with "goofy" happenings of blank rows, but it usually something that I do by mistake while working in the sheet itself.

To answer your question, I don't believe an automation to move rows out of your sheet could cause blank rows, but that's not to say I am 100% confident.

One possible solution, though it is kind of "hackey", is to set up a Trash sheet, then set an automation in your sheet to move any blank rows to the Trash sheet at periodic intervals.