如何跟進行動項目：何時提醒、何時升級，以及如何結案

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.