I have a table of months.
I have a table of internship duties, each one chooses which month they will be completed in (some are just one month, some will be done over the course of many months). So options for an internship duty might look like the following:
[duty column] Answer emails [month column (lookup from table)] March, April, May [# of hours] 5
[duty column] Event 1 [month column (lookup from table)] March [# of hours] 10
What I want to do is in a separate table (separated by role), summarize ALL of March’s hours. So in this example the table would pull
March: Answer emails - 5 hours, and Event 1 10 hours = 15 total hours in March.
What it’s doing is returning each COMBINATION of months as rows in the table. So it would so show
- March, April, May
As my options instead of counting ‘answer emails’ in each of march, April, and May’s rows.
Here’s a video explanation if it helps: Screen Recording 2021-02-14...