This is a bit random, but when someone submits a new form entry to my app, the data appears a few rows down from the prior entry in the spreadsheet (e.g. on row 220 instead of row 210). Anyone know why it might be ‘jumping’ rows like this?
Sometimes the empty rows are considered non-empty and new data is added in the end of the sheet. It may also happen if your sheet has formulas inserted in the rows already.
Check this out
Thank you Manan