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
- 65.4K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 490 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives