A carpool spreadsheet looks orderly at first, but it becomes stale as soon as people reply in chat, change departure times, or assume the return trip is the same. A useful plan gives every driver one visible ride, counts claimed seats immediately, and gives people without a match a clear place to ask.
Use one current source of truth
Choose one board as the live plan and keep discussion in chat only for context. A ride should show the driver, departure, meeting point, total passenger seats, and the groups already joining. Do not copy the same information into multiple messages. Share the private board link again when the plan changes materially.
Collect the event before the cars
Start with a recognisable event name, broad destination, and event time. This gives every driver the same reference and prevents a ride from being added to the wrong day. A venue name is usually enough. Avoid collecting home addresses or precise routes when the trusted group can agree on a public meeting point.
Let drivers describe concrete offers
Ask each driver to add the direction, departure time, meeting point, and actual passenger capacity. The capacity should exclude the driver and account for luggage or equipment. Passengers then claim the number of seats their group needs. Remaining capacity becomes visible without anyone recalculating a column.
Keep unmatched demand visible
A person who cannot use an existing ride should add a request with direction and seat count. A broad pickup area can help, but a home address is unnecessary. Requests are not automatic assignments. The group still confirms a suitable ride directly and removes the request once the plan is settled.