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
-
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
Answers
-
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 - Thank you for the explanation! makes sense why now.
-
Happy to assist!
