forms and empty sheet rows except for the ID (Locked primary column)

Jenn RB

We have a form to support entry of data for requests. Occasionally I have found several empty rows except for the ID field in our sheet, and I would like to understand why that happens so I can educate my team.

NeilKY

If I understand correctly, that's the question I asked and was answered here:

https://community.smartsheet.com/discussion/137694/why-does-smartsheet-add-empty-rows-to-sheets-can-this-be-disabled

Jenn RB

Thanks for the assist, That is not specifically what is happening. No one should be directly doing anything to add a new item to the sheet. The form should drive it. But we appear to be having issues, almost like a blank form was submitted. then it enters rows for them- and because we have automation with ids it wastes the ID numbers.

MedaUser

Hi @Jenn RB,

You say you have automation with ids? Can you share what the automation is? This might be causing your issue.

Isaac A.

Hi @Jenn RB!

In addition to what @MedaUser mentioned, it’s definitely worth checking the Activity Log for your sheet. The Activity Log lets you review the changes made, including when rows are added and by which source, this can help determine if the form is indeed submitting blank responses or if something else is triggering new rows.

You can find more information here: Track changes with the activity log

I hope this helps!

Cheers,
Isaac.