This article is AI-generated.
The tracker is usually not the problem. Most teams have somewhere the action items live. What goes wrong is the bit between meetings: nobody is sure when it's polite to nudge, so nobody does; overdue items get raised once and then forgotten; and items that were quietly finished never get marked done, so the list stops being believable.
This article is about the follow-up routine, not the tracker layout. It covers a simple rule for when to nudge, when to escalate, and how to close items properly, plus one formula that tells you which of the three to do for each row today. The day counts are illustrative; pick the ones that suit your team. Names are placeholders.
The minimum columns
You only need six columns for the routine to work:
| Column | Field |
|---|---|
| A | Action (written as something you can check) |
| B | Owner (one person) |
| C | Due date |
| D | Status: Open / In progress / Done / Dropped |
| E | Done on |
| F | Last nudged |
The column people skip is Last nudged. Without it, you can't tell whether you're about to nudge someone for the first time or the fourth.
The rule
Here's an example rule (adjust the numbers):
- One working day before due: a heads-up to the owner. Short, no pressure.
- Overdue: a nudge, then wait 3 days before nudging again.
- 7 days overdue: escalate. Raise it with the person who set the priority, or put it on the next meeting's agenda by name.
- Done without a date: ask the owner to add the date. An item isn't closed until it says when.
- No owner or no due date: fix that first. You can't follow up on an item that belongs to nobody.
One formula for "what do I do today?"
G2:
=IF(D2="Dropped","",IF(D2="Done",IF(E2="","DONE - ADD DATE",""),IF(B2="","NO OWNER",IF(C2="","NO DUE DATE",IF(TODAY()-C2>=7,"ESCALATE",IF(C2<TODAY(),IF(OR(F2="",TODAY()-F2>=3),"NUDGE","WAIT"),IF(C2-TODAY()<=1,"HEADS-UP","")))))))
We ran it in LibreOffice with today set to 2026-10-14, covering the awkward cases:
| Action | Owner | Due | Status | Done on | Last nudged | Next step |
|---|---|---|---|---|---|---|
| Send revised layout | Owner A | 2026-10-15 | Open | HEADS-UP | ||
| Book supplier visit | Owner B | 2026-10-10 | In progress | NUDGE | ||
| Update training slides | Owner B | 2026-10-10 | In progress | 2026-10-13 | WAIT | |
| Confirm spare parts list | Owner C | 2026-10-01 | Open | 2026-10-13 | ESCALATE | |
| Share site photos | Owner A | 2026-10-09 | Done | DONE - ADD DATE | ||
| Circulate notes | Owner A | 2026-10-09 | Done | 2026-10-09 | (blank) | |
| Review layout options | Owner C | (blank) | Open | NO DUE DATE | ||
| Draft visitor rules | (blank) | 2026-10-20 | Open | NO OWNER | ||
| Old request | Owner C | 2026-10-01 | Dropped | (blank) |
(Illustrative data.)
"In progress" doesn't stop an item counting as overdue. Owners saying they're on it is useful information, but the due date still passed.
How to word the nudge
- Name the item and the date, not "just checking in".
- Ask one question: what's blocking it, and what's the new date?
- Make it easy to say "done": "If it's finished, reply with the date and I'll close it."
- Write the new date into the tracker and keep the original due date in its own column, so slips stay visible.
- Update Last nudged the same day.
Closing the loop
At the next meeting, go through only three groups: ESCALATE, NUDGE, and DONE - ADD DATE. Read out what was closed since last time in one line. Items that were dropped get a sentence on who decided and why, then stay in the sheet as history.
Common gaps
- Nudging by memory. Without Last nudged, some people get chased daily and others never.
- Escalation that's a surprise. Agree the escalation rule in advance so it isn't personal.
- Moving the due date silently. Keep the original date visible.
- "Done" with nothing to show. A done date (and where the output is) makes it checkable.
- No owner on new items. Assign one before the meeting ends.
Following up well isn't about being pushy. It's about a rule everyone knows in advance, a record of when you last asked, and a clear moment when an item is closed. With those three, the list stays believable.
Top comments (0)