Virtual columns Vs spreadsheet formulas + workflow Vs App formula + workflow

[Rafael_ANEIC-PY]

Hello creators, im making an app that needs to recalculate 2 columns of a list of items everytime a new entry is added to the app and show those refreshed values to the user, as far as i know there’s 3 options for me to solve this:

1-Making those 2 columns virtual columns so they recalculate on every sync
2-Building my formulas on the source spreadsheet, using a workflow to force a refresh everytime a new entry is added to the app
3-Building my formulas using expresions inside the app as app formulas, also using a workflow to trigger a refresh on every new entry

Im not sure which one of these would be better from a performance point of view, and since the entries can be modified the solution should be able to trigger a refresh of the data when a row is modified, which path should i choose?

[Steve · Accepted solution]

Virtual columns are the best option to start with.

[Rafael_ANEIC-PY]

Thank you Steve, i’ll go with the virtual columns then