Hi everyone,
I was trying to find a way to grab data from nested forms and add it up automatically in the main form.
Example:
If I have something like this, and I add various groups of people
But then I want to automatically add up all the number of people in the "Total people" Column. Is this something that can be done in AppSheet? If so, do you have any idea how?
Thanks for the help.
Solved! Go to Solution.
I did not test it in a form, but what about:
SUM([Related Groups][NumberOfPeople])
For reference:
https://help.appsheet.com/en/articles/2357307-sum
https://help.appsheet.com/en/articles/4575708-list-dereference
EDIT : Corrected. I misread your question at first
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |