How to Track Who Signed Up and Who Backed Out

You booked catering for 40. Now you are staring at a sheet that says 40, but three people texted you they cannot make it, one asked to switch from Saturday to Sunday, and two names look suspiciously like the same person entered twice. The count on paper stopped matching reality days ago. Here is how to run a live sign up so the number you see is the number you can trust.

Set up the sheet so changes are easy to make

Most tracking headaches start at setup. If your sheet only captures a name, you have no way to reach someone when plans change, and no way to tell two Sarahs apart.

Build the form with the fields you will actually need to manage the list later. At minimum, collect a name and an email. Add a phone field if you plan to confirm closer to the date. If people are choosing between slots or dates, give each option its own line so a switch is a matter of moving one person, not editing free text.

Set a maximum on any slot that has a real limit. On an online signup sheet built with Grasshopper Signup, you cap the number of spots per option and they lock automatically once full. That single setting prevents the most common overbooking problem: two people grabbing the last spot in the same minute because nobody was watching.

If you are not sure what fields to include, start from one of the signup form templates and trim what you do not need. Fewer fields means fewer typos to clean up later.

Watch sign-ups come in without babysitting the page

Once the link is out, you do not need to keep the sheet open. Turn on email notifications so you get a message each time someone signs up. Now the list comes to you, and you have a running record in your inbox even before you open the dashboard.

Check the live list once a day, not once an hour. When you do, look for three things:

1. Duplicates. Two entries with the same name or email usually mean someone submitted twice. Delete the extra.
2. Blanks and typos. An email with no @ cannot be reminded or confirmed. Fix it or reach out.
3. Capacity. See how close each option is to its limit so you know whether to promote the link harder or start pointing people to other slots.

Because the form stays editable after you publish, you can adjust as you go. Add a second Saturday slot if the first fills. Extend a deadline. Rename an option that confused people. None of that requires a new link, so everyone who already signed up stays where they are.

Handle cancellations and switches on a live list

This is where a paper sheet falls apart and a digital one earns its keep. People back out. Plan for it instead of reacting to it.

When someone tells you they are out, remove their entry from the sheet the same day. That reopens the spot, and if you capped that option, the slot unlocks for the next person automatically. Do it promptly. A cancellation you sit on for a week is a spot nobody could claim during the exact window you needed it filled.

For a switch, move the person from the old option to the new one rather than deleting and re-adding. You keep their contact details and avoid a gap in your records. If someone messages you asking to change, it is faster to update the entry yourself than to walk them through resubmitting.

For popular events, let overflow work for you. Turn on a waitlist so people who arrive after a slot fills still get on the list in order. When a cancellation opens a spot, you can pull the next name. On the Boost plan, waitlisted people get an automatic notification the moment a spot opens, so you are not manually chasing replacements at 9pm. This kind of ongoing churn is exactly what tools for managing registrations over time are built to absorb.

Confirm attendance before the day

A name on a sheet three weeks out is a soft yes. The closer you get, the more you want to convert soft yeses into confirmed attendance so your final count is real.

Schedule an automatic email reminder to go out a few days before the event. A reminder does two jobs: it nudges the people who forgot, and it flushes out the ones who can no longer come. Every reply that says "sorry, cannot make it" is a cancellation you can process now instead of discovering at the door. In the US, the Boost plan adds SMS reminders, which tend to get faster replies than email for last-minute confirmations.

If you want people to double-check each other's plans, turn on a public response summary so participants can see who is coming. For a potluck or a shift schedule, a shared view also cuts down on the questions you would otherwise field one by one. This works well for a church potluck signup or a carpool schedule where everyone benefits from seeing the current lineup.

Keep the record after the event

Once the event is over, your list is still useful. It tells you who actually showed, who bailed last minute, and which slots were oversubscribed. On a paid plan you can export the full response data to CSV, which matters when you are reconciling a headcount against what you paid for or planning next time.

Even on the free plan every response is stored, so nothing you collected disappears. Save the form as a reusable template and you start your next round with the fields and capacity limits already set. The next time 40 people sign up and eight change their minds, you will already know exactly how to keep the count honest.

Start a free sign up sheet and set your slot limits before you share the link. That one step does most of the tracking for you.