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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives