The table looks normal. We canโt see the additional columns beyond #9 but Iโll assume they are not out of the ordinary.
A question occurred to me, each day are you seeing the insertions happening progressively further down on the sheet? Or do they jump around, i.e. Day 1 starts at row 58, Day 2 starts at row 5000, Day 3 jumps back up to row 1258, etc?
I donโt know the history of the sheet. The only thing that I can think of is that the rows being skipped are occupied somehow. All it takes is a space in a column somewhere in that row, even in unused columns, for that row to be marked as used.
Here is what I recommend. Copy the sheet for backup. DELETE all unused columns. DELETE all rows you believe to be empty. This will not impact the app and should retain the data in the undeleted rows. Re-sync the app.
Why do this? If you are using Google, sheets typically default to 26 columns and 1000 rows. The unused columns and rows DO add a small bit of overhead in data size and WILL slow down synchronization. If your app has a lot of sheets, the unused portions can really add up. As a common practice, I suggest keeping the sheets trimmed to only what is being used.
Once you have done this โcleanupโ, monitor the usage of the app. If you again see rows insert down in the sheet further than expected, then this likely means that something is unexpectedly inserting rows in your table. If the unexpected rows look empty, check for the existence of spaces in one of the columns.
I cannot think of any other reason you could be experiencing the issue you have described.
LinkedIn
Twitter
