Event Attendee Management help
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
Comments
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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)
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!