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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives