Blank rows added after a new entry is created through form, why?
Why is it that it keeps occurring to me that when I get a new row of information (populated by a form) about 10 additional BLANK rows get instantly added on my main sheet? I have to keep deleting this manually and it's just adding a ton of manual work. Any explanations, solutions to this?
Answers
-
Hi @Rodrigo Blotte ,
Are the blank rows after the new row of data or between the old row and the new?
If the blank rows are between, it's because there was previously data in those rows and instead of deleting the row as a whole, the data was deleted from the cells, essentially leaving a blank row behind.
If the blank rows are after, what is the actual concern? These rows have no data so would not impact reporting, formulas, etc. You can see they are not really rows if you have any sort of automatic cells, like created date or auto-number, those cells are still blank.
Please explain why this is an issue and I can try to help further.
Hope this helps,
Dave
-
Smartsheet will always maintain a minimum of 50 rows in a sheet or 10 blank rows. If you only have 20 rows, then the sheet will go down to 50. If you have more than 50 rows such as 100, then the sheet will go down to 110.
What types of issues are these blank rows causing you?
-
@DKazatsky2 the blank rows are between the old row and the new one, yes.
-
@Rodrigo Blotte, this can typically be resolved by simply adjusting your settings for this form to have new submissions appearing at the top of the sheet instead of the bottom. See below.
-
If they are populating between form entries, then you are not deleting the rows. You are only deleting the data out of the cells. Try deleting the rows by using the row menu (three vertical dots to the left of the row number).
