Gap in between line entries in sheet

jeanniesry_4

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.

Ric T

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.

Cheers,

Ric

Ric T

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.

Cheers,

Ric

jeanniesry_4

@Ric T - Thank you for the explanation! makes sense why now.

Ric T

Happy to assist!