Gap in between line entries in sheet


Hello, wondering if someone can help me.

I have a sheet where new entries are automatically added to the bottom of the sheet list via a form. From time to time, I see that a gap in the sheet is created between the new line entries. As you can see in the Row ID column, the assigned ID# is still sequential but a gap exists in btw. Does anyone know why this random gap keeps happening? See screenshot.

Best Answer

  • Ric T
    Ric T ✭✭✭✭✭✭
    Answer ✓

    Hi @jeanniesry_4, the gap usually happens when something was typed (either intentionally or accidentally) in those blank rows before a form was submitted. If you delete those empty rows, it'll reset so new entries will continue to empty from the bottom.