HI friends,
I'm new to appsheet and want to use it for some simple database functions. For this specific problem I have numerous mentors and partners who volunteer with our non-profit. I want to sum the hours they volunteer with us based on what programs they volunteer for. I have a table with the program data and a table with the mentor data and I want one of the columns in the mentor table to sum the hours they have volunteered with us. In the program table I have a column where I designate how long the program was [hours] and a column where I use Enum Reference to select 1 or 10 or 100 mentors, [partners in attendance]. I want on the partner page to auto sum how many hours they have volunteered with us but I can't quite get the formula right. In sheets it would be similar to a sumif, but I'm having issues understanding some of the previous answers to other questions.
Talk to me like in 10 as I used to say when asking someone to explain something to me haha!
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
4 |