I have a spreadsheet formula in Google Sheets, that AppSheet detected and translated into a R1C1 formula in the app. Normally, when a new row is added through the app, this R1C1 notation should get translated back to an A1 notation so that it works in the sheet, but for some reason, it does not.
An example of a formula in Google Sheet: =SUM.HVISER(Ordrer!F:F;Ordrer!B:B;B:B;Ordrer!J:J;D:D;Ordrer!X:X)
What Appsheet translates it to:
This formula is also what is inserted into the cell in the sheet, breaking the formula. I’ve tried regenerating the table but to no help. Any ideas? It hasn’t always acted like this, but I do not know what triggered this change