Sign-ups come in through a Google Form. At the door, people write their names on a paper sheet. A week later your advisor asks how many of the people who signed up actually came. Now you're matching 40 names by hand, and trying to decide if "Sam R." on the sheet is "Samantha Rivera" from the form.
What you can't answer with two lists
As long as sign-ups and attendance are separate, these questions take an afternoon each:
- What's our no-show rate? You need to know who signed up and didn't come, which means matching every name.
- Who's reliable? When you have 12 seats in a van or need someone to lead next semester, you want the people who come when they say they will.
- How many hours does each person have? Hours come from attendance, but the member's email and contact info are usually in the sign-up form.
- Did the reminder work? You can't compare show-up before and after a change if you never measured it.
The math is easy. The slow part is matching a row in one file to a scribble in another, for every person.
Counting doesn't get you out of it either. Say 30 people signed up for a cleanup and 24 names are on the sheet at the door. It looks like 6 no-shows. But if 8 of those 24 were walk-ins who never signed up, then only 16 of your 30 sign-ups came, and 14 didn't. Two totals can't tell those two stories apart. Only matching the names can.
What matching the lists shows
Here's what you see once sign-ups and check-ins are the same records. We looked at people on Helptivo who signed up at least two hours before an event that used QR check-in. It's a small sample (169 sign-ups at 4 clubs), but it shows the kind of thing you can only learn from one list.
| Group | Checked in |
|---|---|
| All advance sign-ups | 73.4% |
| Typical event (median) | 77.5% |
| Signed up in the last 24 hours | 86% |
| Signed up 1 to 3 days before | 68% |
| Signed up 3 to 7 days before | 71% |
Helptivo data: 169 sign-ups made 2+ hours ahead at 8 QR check-in events run by 4 clubs, February to November 2026. Walk-ins and test or demo accounts excluded.
So roughly 1 in 4 people who sign up don't come. Your own number will be different, and the only way to find it is to compare the two lists every time. For what to do about it, see how to reduce no-shows.
Walk-ins belong on the same list
The sign-up list isn't the whole story either. On Helptivo, 91.6% of QR check-ins are walk-ins, people who came without signing up first.
If walk-ins only exist on a paper sheet, they never make it into your member list. They don't get the next email, and their hours don't count anywhere. Add every walk-in as a row with a name and an email, right next to the people who signed up.
How to make it one list by hand
You don't need software for this. You need one sheet, the same fields at sign-up and at the door, and email as the thing that ties a person's rows together.
One-list event sheet (Google Sheets)
COLUMNS A: Date | B: Event | C: Name | D: Email | E: Signed up (Y/N) | F: Came (Y/N) | G: Hours BEFORE THE EVENT Paste every sign-up in as a row with E = Y and F = N. AT THE DOOR Find the person's row and change F to Y. Walk-ins: add a new row with E = N and F = Y. Always get an email. AFTER THE EVENT Fill in hours for everyone with F = Y. FORMULAS No-show rate for one event: =COUNTIFS(B:B,"Beach Cleanup",E:E,"Y",F:F,"N")/COUNTIFS(B:B,"Beach Cleanup",E:E,"Y") Reliability for one person: =COUNTIFS(D:D,"name@email.com",E:E,"Y",F:F,"Y")/COUNTIFS(D:D,"name@email.com",E:E,"Y") Total hours for one person: =SUMIF(D:D,"name@email.com",G:G)
Swap in your own event name and email. Format the first two formulas as percentages.
Two habits make this sheet work. Ask for the email the same way on the sign-up form and at the door, and type up any paper the same day, before the handwriting gets hard to read. If someone uses two emails, pick one and fix their old rows so their history stays in one place.
This works well for a small club with one organizer. It gets harder with several officers editing at once, lots of events, or a line at the door while someone searches for a row.
What to do with the answers
- No-show rate: if a quarter of sign-ups don't come, let a few more people sign up than you have room for, as long as going over a little is safe.
- Reliability: give limited spots (a trip, a van, a speaker's small session) to people who show up, and ask your most reliable members if they'd like to help lead.
- Hours: when a member asks for their total in the spring, you look it up instead of digging through old files.
- Walk-ins: email first-timers within a couple of days with the next event. Our post on keeping members coming back has a message for this.
How we handle this in Helptivo
In Helptivo, the sign-up list and the check-in list are the same list. Sign-ups and walk-ins are matched to your members by email, so each person has one profile with their sign-ups, check-ins and hours.
Every member gets a reliability rate. You can search members by no-shows, reliability or hours, and export all of it in a member report.
Start with your next event
Don't try to fix last year's records. At your next event, use one sheet (or one tool) for both sign-ups and the door, and get an email from everyone. After three or four events, you'll know your no-show rate and who your regulars are, instead of guessing.
Questions people ask
What is a reliability rate for volunteers?
The share of events someone actually came to after signing up. If they signed up for 5 events and came to 4, their reliability is 80%.
How do I calculate a no-show rate?
Take the people who signed up and did not come, and divide by everyone who signed up. Leave walk-ins out of both numbers, since they never signed up.
Can I connect Google Forms sign-ups to attendance?
Yes, if the sign-up and the check-in both ask for email and end up in the same spreadsheet. Then you match rows by email. There is a sheet layout with formulas in this post.
Why match by email instead of name?
People write their names differently every time: nicknames, initials, typos. An email is usually the same, so it's the only safe way to know two rows are the same person.

