Event guest list template

One row is one guest, and whether they are actually coming. Co-hosts, sponsors, and partner companies, each sending their own allocation as a separate list a week before the event.

FieldTypeRulesNote
NametextRequired
EmailemailRequiredUnique
Ticket typeenumGeneral · VIP · Speaker · Staff · PressRequired
AttendingbooleanRequired
Plus onesnumberOptional
Dietary requirementstextOptional
CompanytextOptional
Registered ondateOptional

What this sheet refuses to accept

The same person on two partners' lists is caught by the unique email instead of being counted twice against catering.

“Yes”, “y”, “TRUE” and “1” all become the same boolean, so the attending count is a number rather than a judgement call.

A plus-one column containing “2 maybe” is rejected rather than quietly rounding to something.

Other sheets people start from