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. Updated September 1, 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 does one person owning the spreadsheet break the rotation?

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 the blank in with a suspicion. The file is not the flaw. Single ownership is, because it makes every assignment unverifiable, including the assignments that followed the rule exactly.

The rotation usually lives in one of three places, and all three share that 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.

Nurses read that opacity the way you would expect. A 2025 focus-group study in BMC Nursing found that current scheduling practices often lacked fairness and transparency, leading to dissatisfaction, particularly among permanent staff, who asked for more autonomy and fairness in how shifts get allocated. The complaint is not usually about the decision. It is about not being able to check it.

What do staff see when the order is hidden?

When the order is not posted, every assignment looks like a decision about a person, even the ones that followed the rule perfectly. Fairness that cannot be seen does not count as fairness on the floor. Staff cannot tell the difference between bad luck and favoritism without the list, and people almost always assume the worse of the two.

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. 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 research names the specific fear. In a 2025 qualitative study of staff nurses and nurse managers, the Western Journal of Nursing Research noted that implicit hierarchies such as preferential scheduling based on friendships may lack transparency to staff. That is the story a hidden order invites, whether or not it is true, and the only refutation is a list anyone can open.

Why does a whiteboard erase 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 record is already wiped. It feels open, because everyone walking past can read it, but a dispute is almost never about today. It is about the third time in a row, last month, a shift somebody swears they already covered.

By the time that argument happens, there is nothing left to check. An open board with no history answers the easy question, whose turn is it right now, and none of the hard ones.

Why is one spreadsheet not enough?

A single spreadsheet gives you a record, but one person owns it and it does not remember its own past. It shows the current state and never how the file got there, which is the one thing a dispute is about. Whoever keeps it also inherits the appearance of controlling it, the exact problem a posted order is supposed to solve.

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 do you fix it without new software?

Two moves get you most of the way: 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. A shared document and a posted sheet will do it, so long as the line actually gets written on the weeks nobody wants to write it.

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 does software fit?

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 read, with a record that writes itself instead of relying on somebody remembering. Nobody has to be trusted to keep it honest, because the order is visible and the history cannot be quietly overwritten.

The cost of drift is measurable. NSI Nursing Solutions reports in its 2026 national retention survey that more than twenty-two percent (22.7%) of all newly hired RNs left within a year, with scheduling conflict among the top five reasons staff RNs voluntarily resigned. A newer nurse has the least standing to ask why she got called in, and the least reason to stay when nobody answers.

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.