Healthcare

Patient Scheduling Tracker

Manage appointments across providers with auto-calculated no-show rate, status pills (Confirmed / Cancelled / No-Show / Completed), per-provider breakdown, and visit-type chart.

What's Inside

Start Here — How to log appointments, what statuses mean, and weekly slot setup per provider.
Appointment Log — One row per appointment with Patient, Provider, Date, Time, Visit Type, Status pills, Phone, Notes.
Provider Schedule — Auto-aggregated per provider — Total Appts, Confirmed, No-Shows, No-Show Rate, Cancelled.
Dashboard — Snapshot (Total Appts, Confirmed, No-Shows, No-Show Rate, Cancelled), per-provider breakdown with no-show rate, Visit Type column chart.

Key Features

No-show rate auto-calculated per provider from the full appointment log.
Status pills (Confirmed / Cancelled / No-Show / Completed) with dropdown validation.
"Confirmed this week" tile so reception knows the load.
Per-provider table flags clinicians with high no-show rates.
Visit type breakdown (New Patient / Follow-up / Procedure) as a column chart.
Date column formatted as "Mon, Mar 2" — readable at a glance.

Sample Formulas

Here are some of the formulas powering this template:

Per-provider no-show rate

=COUNTIFS('Appointment Log'!B:B,"Dr. Smith",'Appointment Log'!F:F,"No-Show") / COUNTIF('Appointment Log'!B:B,"Dr. Smith")

Total confirmed appointments

=COUNTIF('Appointment Log'!F:F,"Confirmed")

Visit type breakdown

=COUNTIF('Appointment Log'!E:E,"New Patient")

Get this template free

Enter your email and we'll give you instant access to copy this template into your Google Drive.

You're in.

Click below to copy this template into your Google Drive. Check your email for setup instructions.

Make a Copy

Need this connected to your EHR?

We build custom scheduling systems that sync with your existing patient management tools — automated confirmations, waitlist management, and real-time availability.

Start a build