Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

SUM using multiple selections from an enum list

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!

0 0 151
0 REPLIES 0
Top Labels in this Space