I am trying to make an Inventory management app, which has in-bound and out-bound products features, so products’ cost and quantity value will change when there are new inventory coming in (plan to use an average for products’ cost)
However, I see some examples from appsheet website that directly put formulas into the google sheet.
I have read https://help.appsheet.com/en/articles/961393-spreadsheet-formulas, but still don’t get it about the differences between using google sheet formula and app formula (I am quite new to the appsheet)
What are the differences between app formulas and google sheet formula?
What are the pros and cons to put formulas in the google sheet vs. app formula?
If you have useful resources or examples, could you please share or give some suggestions?
Solved! Go to Solution.
Hey @Poovich.
There are some big differences between sheet formulas and app formulas, I’ll try and highlight things below.
Computed by a server
all g-sheet formulas available (including custom formulas you might create with apps script)
Only calculated when new data hits the sheet
Computed by the end-user device
limited to only those supported by AppSheet
IF INSIDE A PHYSICAL COLUMN:
IF INSIDE A VIRTUAL COLUMN:
My general rule of thumb is this:
Treat your Google sheet like it’s a database table; it’s just a place to store data.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |