Skip to content
On-Call Rotation Schedule cover: a sample sheet with weeks planned, incidents logged and sev 1 incidents and a bar chart, beside the Dashboard and Rota tabs

On-Call Rotation Schedule

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The on-call rotation schedule is for engineering managers and team leads who run a weekly primary and secondary rota. The Rota tab lists each week's start date, the primary and secondary engineer and a handover note, and a row turns red when one person holds both roles. The Incidents tab records each page with its severity, time to acknowledge and time to resolve, and the dashboard compares weeks on call with incidents for each engineer.

Plan the rota at least six weeks ahead, and copy the file each quarter so older rows stay for reference. Log each page as an Incidents row that same day while details are fresh, and keep the summary brief. Look at the load table before you set the next month's rota, and move a week away from anyone who has handled more than their share of Sev 1 pages.

Useful for

  • Setting primary and backup weeks for an engineering team
  • Reviewing how many pages each engineer took last quarter
  • Spotting the services that page the team most often

What's included

  • 4 tabs: Dashboard, Rota, Incidents, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Rota: a table
  • Incidents: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Rota tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I add an engineer to the lists?

Type the name in the list of engineers on the Rota tab and the list on the Incidents tab (Data, then Data validation). The dashboard table lists engineers by name, so add a row for them there too.

What does minutes to resolve measure?

It is the time from the page to the all-clear, typed in minutes by the engineer on call. The dashboard takes the mean across every incident, so one long outage pulls the figure up, which is why severity is logged too.

Can the sheet track paid on-call time?

Not in this version. It counts weeks and incidents, not pay or time off in lieu. Add a separate column or a payroll sheet if on-call is paid, and check your employment terms.

  • #shift-schedule
  • #on-call-rotation
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More shift schedule templates

See all 9

Also in Human resources

All human resources templates
Get this template

Preparing your template…