I’d like to ask about the “Spreadsheet formulas” that
AppSheet creates for columns in our spreadsheets that contain formulas.
Here’s my question: What happens (or what should happen) to the “Spreadsheet formula” inside the AppSheet editor when we change the related formula in our Google spreadsheet?
I’ve been having some trouble with a sync issue recently (see https://plus.google.com/105035465983967629689/posts/Fkax6VuS7vp ) and so have been trying to tweak my spreadsheet and app to resolve it.
I noticed that even though I changed a formula on my spreadsheet, that change was not reflected in the “Spreadsheet formula” inside the app editor.
I used the “Regenerate” function, but to no avail.
I’m considering altering the formula by hand but I can’t understand why a formula that was generated automatically cannot be regenerated automatically as well.
Actually, even if I delete a formula, the performance of that column seems to be unchanged, so what’s going on?