Hello all, can help me how use formula =O6+M7-N7 at Appsheet .
Thanks you
Hello A_Syaeful,
I am assuming O6, M7, and N7 are spreadsheet cells. Appsheet, and Spreadsheet formula are different and complimentary to each other. (https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values)
You can represent some in-row spreadsheet formula (https://help.appsheet.com/en/articles/961393-spreadsheet-formulas) by an App formula. Currently, it is better to keep multi row formula (your example) in SpreadSheet.
A variation of in-row formula similar to your example (but not same) that can be migrated to App formula.
SpreadSheet formula: Pi = Oi + Mi - Ni for all rows, where i is the range of rows.
App formula: You can create a virtual column called P (just an example. In reality you might need to have a better name for this column), and set the App formula as [O]+[M]-[N].
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |