Event Management and Attendee list help
We are hoping to use Smartsheets for event management, with a master sheet having columns such as 'Name, Role, Company' and additional columns being the Event name (drop down list with dates) and 'I would like to attend this event' (checkbox)
We would then create a form for each event, using the basic columns and then using whichever event column we needed with the drop down dates.
What I'd like to understand is this.
E.g. Joe Bloggs attends three separate events. In the master sheet, his name would appear in three separate rows, showing his selection cascading across event 1 (yes), event 2 (yes), event 3 (yes).
Is there a way We could amalgamate that row in another sheet, perhaps, that would have joe bloggs on one row with checkboxes showing the events he's put down to attend?
Any help would be most welcome!
Help Article Resources
Check out the Formula Handbook template!