How to group by contact?

edited 04/04/24 in Smartsheet Basics

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?



  • Leibel S
    Leibel S ✭✭✭✭✭✭

    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))