Overview
Works for any service business that takes appointment requests through a website form and needs a readable queue of upcoming bookings. Not a replacement for Calendly, but the right fit when you want the data alongside your CRM-like sheet.
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 |
|---|---|
| Booking ID | Unique ID |
| Requested at | Timestamp |
| Client | Name |
| Phone | |
| Service | Dropdown of your service offerings |
| Duration (min) | |
| Preferred date 1 | |
| Preferred date 2 | Optional second choice |
| Assigned date | Date - set when confirmed |
| Assigned staff | |
| Status | Requested / Confirmed / Completed / No-show / Cancelled |
| Confirmation sent? | Boolean |
| Reminder sent? | Boolean |
| Notes | Freeform |
Useful formulas
Paste these into a top-of-sheet summary row or a separate dashboard tab.
Upcoming (next 7 days)
=COUNTIFS(J:J,">="&TODAY(),J:J,"<"&TODAY()+7,L:L,"Confirmed")No-show rate
=COUNTIF(L:L,"No-show")/(COUNTIF(L:L,"Completed")+COUNTIF(L:L,"No-show"))Conditional formatting
- Status: green for Confirmed/Completed, red for No-show/Cancelled, yellow for Requested.
- Confirmation / Reminder columns: red if FALSE and Assigned date is in the future - catches missing comms.
Pivot table guidance
Pivot by Assigned staff with Status as columns. Second pivot: Service by month - identify demand patterns.