How to group by contact?
Hi everyone!
I'm looking for the most efficient way to address this issue and I hope someone can help me.
Currently, I have a form that permits multiple contact entries. This form is used to record the names of participants at an event. The form populates a sheet in such a way that all participant names for an event are listed within a single row.
I'd like to view, for instance, all the events that each person has participated in, grouped by person rather than by event. As an example, I'd like to see all the events I've personally attended. Is there a workaround for displaying this information?
Answers
-
Not through using grouped reports.
You could make a sheet that has a list of all possible participants, then looks up the events sheet to bring back all the Events that person participated in.
the formula would be something like:
=JOIN(COLLECT({Events},{Attendees}, HAS(@cell, [Person]@row)),CHAR(10))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives