Event Attendee Management help

HollywoodStu

Hello there,

I'm hoping someone can help me find a solution to a problem regarding the creation of an event management system for events.

Background:

A company I am assisting has a number of in person and webinar events. The attendees aren't from a defined list they have, events could be attended by anyone within the sector.

The company would like to be able to have a master sheet showing the name of attendee and a checklist of events they've attended.

What I've done so far:

I've created individual event sheets for each of the 9 events they've held to date.

What I need to be able to do is have a sheet that sits above these 9 events that is able to display attendee name and a checkbox for each event where they've attended.

Issue/Question

Whilst I've been assisted in how to do this within this thread here: Event Management and Attendee list help — Smartsheet Community, what I'm having issue with is this:

Because the events can be attended by anyone, how do new names/attendees get added to the 'master' sheet that sits above? Does this have to be manually cross checked and added, or is there a way?

Thanks in advance,

Stuart

Andrée Starå

Hi @HollywoodStu

I hope you're well and safe!

Have you explored using a Report instead?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

HollywoodStu

Hi @Andrée Starå

I haven't explored this option, no - curious though to understand how it work work in terms of collating attendees into one row, showing which events 1 x person has attended.

So, for e.g., Person one attends Webinar 1, 2 and 3 - captured within 3 separate sheets.

How could this be displayed within a report on one line showing:

Person one Webinar 1, 2, 3 (tick, tick, tick)

Andrée Starå

@HollywoodStu

You could use the grouping feature, but it would show on separate rows instead but grouped by the attendee.

Make sense?

Would that work? It's the simplest solution.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!