Overview
This template handles 10-1,000 attendee events cleanly. Captures registration data, enforces ticket-type capacity limits via conditional formulas, and includes a check-in workflow for the day of the event.
Column layout
Copy this column order into a blank Google Sheet, or let SheetLink Forms create the headers for you on first submission.
| Column | Notes |
|---|---|
| Registration ID | SheetLink-generated unique ID |
| Timestamp | When they registered |
| Name | Attendee name |
| Confirmation email will go here | |
| Company | Optional |
| Ticket type | Dropdown: General / VIP / Speaker / Press / Sponsor |
| Sessions | Multi-select - breakout session preferences |
| Dietary | Freeform - vegetarian, gluten-free, nut allergy, etc. |
| Accessibility | Freeform - wheelchair, ASL, etc. |
| How did you hear? | Source survey question |
| UTM campaign | Marketing attribution |
| Referral code | Optional discount or attribution code |
| Payment status | Paid / Comped / Refunded |
| Checked in? | Boolean - updated at the door |
| Feedback | Post-event - filled in after they fill the feedback form |
Useful formulas
Paste these into a top-of-sheet summary row or a separate dashboard tab.
Total registered
=COUNTA(A2:A)-1Running headcount.
VIP count
=COUNTIF(F:F,"VIP")Live count per ticket type.
Check-in rate
=COUNTIF(N:N,TRUE)/(COUNTA(A2:A)-1)Show of registrants who actually showed up.
Conditional formatting
- Ticket type: conditional formatting - gold for VIP, blue for Speaker, green for General, red for Press.
- Checked-in column: green background when TRUE.
- Dietary / Accessibility: yellow background if not blank - flags rows that need venue coordination.
Pivot table guidance
Pivot with Ticket type as rows, counts as values. Shows the ticket mix and validates against your venue capacity plan.
Recommended add-ons
- Conditional Routing: Route speaker applications to a separate sheet owned by the program committee.