Hi folks.
I was looking for some guidance.
I have a ledger and balance sheet on gsheets. I wondered what is the best way to tackle the sumif part. eg if account is "events" total up all entries that are events to give me a total on balance sheet, the same with other accounts.
Thank you
Solved! Go to Solution.
I think the advice from Guillermo here is completely off-base.
The basic equivalent of SUMIF in Appsheet is SUM(SELECT()). See their help articles here:
https://help.appsheet.com/en/articles/2357307-sum
https://help.appsheet.com/en/articles/2357314-select
As far as where to put the expression, read here:
https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values
And it will also be helpful to start learning about references between Tables, which may help you even more here, but is not 100% necessary to achieve what you're wanting.
https://help.appsheet.com/en/articles/961426-references-between-tables
Hi Im a bit of a beginner but will have a go. Where would this code go?
I think the advice from Guillermo here is completely off-base.
The basic equivalent of SUMIF in Appsheet is SUM(SELECT()). See their help articles here:
https://help.appsheet.com/en/articles/2357307-sum
https://help.appsheet.com/en/articles/2357314-select
As far as where to put the expression, read here:
https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values
And it will also be helpful to start learning about references between Tables, which may help you even more here, but is not 100% necessary to achieve what you're wanting.
https://help.appsheet.com/en/articles/961426-references-between-tables
hola amigo, soy nuevo también en el uso de esta herramienta y agradezco todas las observación que me hagan, las cuales me sirven para aprender más, seguiré su recomendación.
muchas gracias.
Thank you will study that looks more sensible.
User | Count |
---|---|
34 | |
31 | |
30 | |
18 | |
17 |