My google sheet has grown substantially with data and I am making some updates by adding columns and adding formulas to calculate sheet columns from expressions in Appsheet.
It seems however that it only does the calculation when I open/edit the form again and it is not calculated for all rows in the table. Is there a delay in populating the google sheet table with the formula outcomes? Is there a way to force this calculation on all the rows?
A data source column configured with an App formula in the AppSheet table will only ever recalculate for a given row when that row is otherwise updated. Techniques to backfill the data include:
Manually populate the data directly in the data source (e.g., replicate the app formula in the spreadsheet and the copy those values into the sheet column).
Create an app automation that forces recalculation of the table’s rows and use the automation’s “test” function to trigger it on demand; you can leave the automation disabled so that it never automatically triggers.