Staff Scheduler Template
Visual shift planning with templates and cost tracking. Drag, drop, and done.
What is this staff scheduler template
Staff Scheduler is a complete, ready-to-run shift-planning system — not a blank grid you have to wrestle into a rota. The moment you copy it into your workspace, you get a visual drag-and-drop planner plus the employee roster, pay rules, holiday calendar, and time-off tracking that feed it, so you can build and cost a real week of shifts in minutes instead of reconciling three spreadsheets.
In practice, the Shift Matrix app is where you build the week: drag a shift onto an employee and the cost adds up as you go. That cost comes from the Employees table's Base Hourly Rate applied to each shift's Start Time, End Time, and Break Minutes in the Shifts table. The Pay Rules table layers multipliers for holidays, weekends, or late hours on top, the Holiday Calendar flags the days that cost extra, and Time Off Requests move through pending, approved, and rejected so you never schedule someone who's away. Reusable Schedule Templates save a typical week so you stop rebuilding it every Monday.
It's built for restaurants and retail, shift-based teams like clinics and warehouses, and the ops managers who build the weekly rota. Use it as-is, or tune the pay-rule multipliers, holiday calendar, and saved week templates to match how you actually staff and pay.
What's inside
Six tables plus a visual planner, all wired together. Employees, pay rules, holidays, and time off feed the schedule, and every shift carries an estimated cost — so the roster you build is one you can actually afford.
Shift Matrix
The visual planner at the heart of the template. Drag shifts onto the grid, drop them onto an employee, and watch the cost add up as you build the week — no more nudging cells in a spreadsheet.
- Drag-and-drop shift planning
- Cost tracking updates as you schedule
- Color-coded by employee
- Built on Teable apps — no separate scheduling tool
Shifts
Every shift as a record: start and end time, break minutes, and an estimated cost. A hundred sample shifts show the shape of a real schedule, ready to clear and refill with your own.
- 100 sample shifts to model the format
- Start / End Time with Break Minutes
- Estimated Cost on every shift
- Notes for shift-specific context
Employees
The roster. Each person has a base hourly rate, a color code for the planner, and an active flag. The rate is what turns a shift's hours into a dollar figure.
- Base Hourly Rate drives cost estimates
- Color Code marks each person in the planner
- Is Active to offboard without deleting history
- 5 sample employees to replace with your team
Pay Rules, Time Off & Holidays
The tables that make the schedule realistic. Pay Rules apply multipliers for holidays, weekends, or late hours; Time Off Requests track sick, vacation, and personal leave through approval; the Holiday Calendar marks the days that cost extra.
- Pay multipliers by holiday, day of week, or time of day
- Time-off requests with pending / approved / rejected status
- 32-entry holiday calendar with country codes
- 3 reusable schedule templates for recurring weeks
Every field a shift schedule actually needs
The Shifts table is the working core — seven fields covering when a shift runs, who's on it, and what it costs. Rename them, add your own, or hide the ones you don't need.
| Field | Type | What it's for |
|---|---|---|
| Shift ID | Text | A unique handle for each shift — keeps the roster tidy. |
| Start Time | Date | When the shift begins — the planner anchors to this. |
| End Time | Date | When it ends — together with start, sets the paid hours. |
| Break Minutes | Number | Unpaid break time, so cost reflects hours actually worked. |
| Estimated Cost | Number | What the shift costs in wages — the number the planner totals up. |
| Notes | Long text | Shift-specific context — station, coverage, special instructions. |
| Employee ID | Text | Who's working — ties the shift to a person on the roster. |
Why teams schedule on this template
A spreadsheet can list shifts. This template plans them visually, prices them as you go, and keeps the rules and leave that shape the week in the same place.
Drag, drop, done
Build the week on a visual grid instead of typing into cells — move a shift by dragging it, not editing a formula.
Costs as you schedule
Every shift carries an estimated cost driven by hourly rates, so you see the week's labor spend before you publish, not after payroll.
Pay rules built in
Multipliers for holidays, weekends, and late hours live in their own table — overtime math stops being a mental side-calculation.
Leave that respects the roster
Time-off requests flow through pending / approved / rejected, so you know who's actually available before you assign the shift.
Reusable week templates
Save a schedule as a template and reuse it — a typical week stops being a from-scratch rebuild every Monday.
Holidays baked in
A 32-entry holiday calendar with country codes flags the days that cost extra, before you accidentally schedule straight through one.
Who it's for
Anyone who builds a weekly rota for hourly staff and is tired of doing it in a spreadsheet that can't add up the cost.
Restaurants & retail
Hourly staff, changing availability, weekend premiums. Build the week's floor plan and see the labor cost before the doors open.
Shift-based teams
Clinics, warehouses, support desks — anywhere coverage matters. Drag shifts onto people and spot the gaps before they become a problem.
Ops & office managers
One base for the roster, the pay rules, and the leave calendar — stop reconciling three spreadsheets and a chat thread every week.
How to use this template
From zero to a published, costed week of shifts in about fifteen minutes.
- 1
Click "Use template"
The whole base — all six tables and the Shift Matrix planner — copies into your workspace. The free tier is plenty to start.
- 2
Add your team
Replace the 5 sample employees with your staff — name, base hourly rate, and a color each. The rate is what prices their shifts.
- 3
Set your rules and calendar
Adjust the pay-rule multipliers for how you pay weekends and holidays, and trim the holiday calendar to your country. Load any approved time off.
- 4
Build the week in the Shift Matrix
Open the planner and drag shifts onto your people. Watch the estimated cost add up, save the week as a template, and reuse it next time.
Make it yours with Teable AI
The template is the starting point, not the ceiling. Teable builds AI into every table — set pay rules by describing them, pull your roster in, and turn the shifts into a cost report. Four ways to turn this scheduler into yours:
Set pay rules in plain words
Pay Rules is a normal table. Tell Teable AI how you actually pay for late nights or weekends and it adds the rule with the right Multiplier and Category — no formula hunting.
Bring your roster in
Don't retype your team. Connect & Migrate pulls your staff list out of Excel or CSV and maps the columns onto Name, Base Hourly Rate, and Employee ID for you.
Automate the leave approvals
Super Automation turns a sentence into a running workflow. Watch Time Off Requests so a pending request pings a manager and an approval tells the employee — no chasing in chat.
Turn shifts into a cost dashboard
Every shift already carries an Estimated Cost. Ask Teable AI for a custom app and it builds a weekly labor-cost view grouped by employee — the report you check before publishing.
Frequently asked questions
Is this staff scheduler really free?
Yes. The template copies into a free Teable workspace, and the free tier covers the tables and the Shift Matrix planner for a small team. You only upgrade if you outgrow the row or attachment limits.
How does the cost tracking work?
Each employee has a Base Hourly Rate, and each shift has a Start Time, End Time, and Break Minutes. From those the template works out an Estimated Cost per shift, so the Shift Matrix can total up the week's labor spend as you drag shifts around.
Can it handle overtime and holiday pay?
Yes. The Pay Rules table holds multipliers categorized by holiday, day of week, or time of day, each with a priority. Adjust the multipliers to match how you actually pay, and the holiday calendar flags the days that trigger them.
How do employees request time off?
The Time Off Requests table tracks each request with a type (Sick, Vacation, Personal, Other) and a status that moves from pending to approved or rejected. Check it before assigning shifts so you never schedule someone who's approved to be away.
Can I reuse a schedule week to week?
Yes. The Schedule Templates table stores reusable weekly layouts with a favorite flag. Save a typical week once, then start from it instead of a blank grid each Monday.
What happens when my team grows?
Keep going. Add employees, build a dashboard app for labor-cost reporting by week or role, or use Teable's API to push shifts into payroll. The template is a starting base, not a ceiling.
Schedule your team in minutes
Duplicate Staff Scheduler into your workspace and publish this week's rota today.
