Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Odd Behavior: New Blank Rows Created from Webform Entry
I'm wondering why the default behavior of a standard sheet is to create 10 to 50 new blank rows when a new webform entry is received.
New blank sheets are created with 50 rows. If you delete 49 rows and generate a new row from a web form then the sheet will automatically create 48 blank rows to bring you back to the 50 row default minimum displayed row count. The new entry appears on row 2.
If you then generate a second new entry from a web form then the sheet will add approximately 10 more rows for a total of 61 rows. The new entry is populated on row 51.
When you generate a third new entry from a web form no new blank rows are created and the new entry is populated on row 52.
The purpose of this test was to determine if specific cells could be automatically populated with formula-based calculations by copying the formula to all cells of a column down to the last row of the starting sheet. I have proven this use case but the creation of all these new blank rows just seems odd.