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?