Best Practice : Should use formula at Spreadsheet(database) level or Appsheet level? and why?

[consultation_co]

Best Practice : Should use formula at Spreadsheet level or Appsheet level? and why?

[Steve]

Spreadsheet formulas will only be evaluated when the app syncs. If the app is used offline, the columns with spreadsheet formulas will not update at all until the app is online again.

Best practice is to use AppSheet expressions.

[consultation_co]

Ok thank you very much.

[Jerry_Lan]

…and appsheet expressions less likely to slow down the app right?

[Steve]

Jerry_Lan:

appsheet expressions less likely to slow down the app right?

In that they can update without a sync, yes. On the other hand, if you have complex/inefficient expressions for virtual columns–that only update in bulk during a sync–it’s possible spreadsheet formulas could be faster. You’d have to test to find out. Still, best practice is to at least start with an AppSheet expression. Always keep in mind, though, that virtual columns will update automatically in forms, but spreadsheet formulas will not.