Hi,
I am currently tracking the number of people who has RSVP for an event.
The view is currently set up:
- The first column is the nominee's name
- The next column is Student RSVP (single select with the option of Accepted, Declined, Pending).
- This column is the supervisor's name who nominated the student
- This column is Supervisor RSVP (single select with the option of Accepted, Declined, Pending)
- Additional Guest (this is a single line for us to enter info e.g., +1 )
- Dietary requirement (this is a single line)
When I filter "Student RSVP is "Accepted", it spits out the records showing students who have accepted the invite but it does cover the case where if the student "Declined" and Supervisor "Accepted".
I also tried grouping them by Student RSVP and Supervisor RSVP. But we still need to calculate ourselves manually to confirm how many accepted, including the additional guest.
My question to the community is - is there a way I can better set it up so that I can instantly see a sum of those who have Accepted?
Thanks,
Eve