Resources · Scheduling

What to do when the on-call rotation lives in one spreadsheet

By Antonimar Mello, BSN, RN, a working perioperative nurse on Long Island and the founder of OnCallRank. Published July 20, 2026.

When the call rotation lives in one spreadsheet, one whiteboard, or one manager's memory, the unit has no way to check whether call is being run fairly. The problem is not the spreadsheet. The problem is that only one person can open it, only one person can change it, and nobody else can see what it said last week.

Why "it's in my spreadsheet" is the real problem

A rotation that lives in one file, controlled by one person, is invisible to everyone who has to trust it. Staff cannot see their place in line, so they fill in the blank with a suspicion.

The rotation usually lives in one of three places, and all three have the same flaw:

• A spreadsheet on the manager's computer. One person can open it, one person can edit it, and there is no history of what changed.
• A whiteboard in the break room. Everyone can see this week, but last month is already erased, so there is nothing to check a complaint against.
• The manager's own memory. This is the most common one, and the one that falls apart the fastest, because memory is exactly what people argue about.

None of these are laziness. They are what a busy unit reaches for because they are fast. The trouble shows up later, the first time a nurse asks "why him again," and the only record of the answer is inside one person's head or one file nobody else can see.

What staff actually see when the order is hidden

If the order is not posted, every assignment looks like a decision, even the ones that followed the rule perfectly. Fairness that cannot be seen does not count as fairness on the floor.

Picture it from the staff side. You get called in on a Saturday. You have no way to look up whether it was your turn, so you cannot tell if the rotation landed on you or the manager landed on you. When you cannot see the order, you cannot tell the difference between bad luck and favoritism, and people almost always assume the worse of the two. The manager may have followed the list exactly. It does not matter, because the list is in a file only they can open, and "trust me, it was your turn" is not an answer anyone accepts twice.

The whiteboard erases the evidence

A whiteboard shows this week and destroys every week before it. The moment a dispute reaches back more than a few days, the only record is gone.

The whiteboard feels open because everyone walking past can read it. But a dispute is almost never about today. It is about last month, about the third time in a row, about a shift someone swears they already covered. By the time that argument happens, the marker is wiped and there is nothing to check. An open board that keeps no history answers the easy question, whose turn is it right now, and none of the hard ones.

The spreadsheet has one editor and no memory

A single spreadsheet gives you a record, but one person owns it, and it does not remember its own past. Whoever keeps the file inherits the appearance of controlling it.

A spreadsheet is a real step up from a whiteboard, because at least the numbers survive. But it still has two holes. First, one person edits it, so the same person who runs the rotation is the only one who can change it, and no one else can watch that happen. Second, a plain spreadsheet does not keep its own history. A cell gets overwritten and the old value is simply gone, with no note of who changed it or when. So when someone says "I was up next and you skipped me," the file cannot defend itself or the manager, because it only shows the current state, never how it got there.

How to fix it without new software

You can get most of the way with two moves: post the order where the whole unit can see it, and keep a dated log line for every assignment, decline, and trade. Visible order, permanent record, no single owner.

Put the order somewhere staff can look at it without asking, a shared document or a posted sheet that shows who is up next and the full list behind them. Then keep a running log, one dated line per event: who was offered, who declined, who was assigned, who traded, and the date each happened. That log is what turns "I think it was your turn" into "here is the line from the ninth."

The honest catch is discipline. The log is easy to keep on a calm week and easy to skip on a bad one, and the bad weeks are the ones that end up in dispute. And whoever maintains the document still looks like they control it, which puts the manager back in the spot the whole exercise was meant to get them out of.

Where software fits

A scheduling tool earns its place when it takes the rotation out of one person's file and makes it something the whole unit can see, with a record that writes itself.

That is the specific job OnCallRank was built for, by a perioperative RN who lived this exact fight from the staff side, scrubbed in while shifts went to the fastest phone and the manager took the blame. The rotation lives in one place the whole unit can see, not in a file on one computer. Staff request an open call shift with one tap, the rotation decides among the requesters, the manager approves, and every offer, decline, assignment, and trade lands in a permanent history with a timestamp and the name of who made the call. Nobody has to remember to write the log, and nobody has to be trusted to keep it honest, because the order is visible and the record is automatic. OnCallRank collects only an email and a password to sign in. There is no patient data anywhere in the product, so there is nothing for hospital IT to review before a unit tries it. If your unit wants to see it on its own roster, the trial is free for three weeks, no card: start your free trial, or book a 15-minute call.