Hi all, hope you will have a good day.
can you please help me to understand what could be the reason that the new ROWS (in just my latest project) are appended to the bottom of the sheet
I’ve obviously verified that there are no ROW ID, no Arrayformula (that might create this effect, I’ve removed those completely to verify this), no FORMAT whatsoever.
it is like Glide take memory of the Last Row used… more or less, because if I delete all rows in any case the new ROW will be added after the last
and actually this is the 1st time I see this .
Any clue how to fix it?
EDIT:
Sorry I just noticed something strange, in Glide there is a Hidden Record:
As you can see from the 1st to the 2nd image there is a record which is not on Google sheet!
So now the question is HOW TO REMOVE IT and why this happen?
PS: from GLIDE, from the Table view, this record is not possible to delete (as it happen with the others)