Has something changed in the way that AppShee...

(Simon Bailey) #1

Has something changed in the way that AppSheet writes onto Google Sheets? It seems to be inserting rows, rather than just putting the data onto the row as it used to.

The problem with this is that I have another sheet with formulas to read each cell from the AppSheet data and these are now not coming through.

(Simon Bailey) #2

Sorry, I’ve realised what’s wrong. The app was having to add rows onto the bottom of the Google Sheet. Now I’ve added more rows manually it’ll work.

(Aleksi Alkio) #3

The app should add them automatically if there is no blank rows already.

(Simon Bailey) #4

@Aleksi_Alkio Yeah, it does, which is usually good, but when there are formulas referring to that sheet the new rows don’t come through. It was my fault, I set it up badly. I shouldn’t have a formula referring to something that doesn’t exist yet :slight_smile:

(Aleksi Alkio) #5