Track Action Items in Excel or Sheets (Free Formulas)

· · Spreadsheet tutorials
Summary

Action items only get done when someone can see them. This guide builds an action items tracker in Excel or Google Sheets from six columns, native checkboxes, and one conditional formatting formula that turns overdue items red on its own. You will also see the COUNTIF formula that counts open versus completed items without opening the sheet, plus where AI meeting notetakers fit before the tracker even starts.

Golden retriever resting beside a laptop showing an action items spreadsheet on a wooden desk

Action items die in three places: the meeting notes nobody reopens, the Slack thread that scrolls away, and the spreadsheet that never gets a second look. The fix isn't a fancier tool. It's a tracker with six columns, a checkbox that means something, and one formula that flags what's late before you have to ask. Below is the exact setup, in Excel and in Google Sheets, plus the formulas that keep it honest.

Your action items list needs six columns, not sixty

Most action item spreadsheets fail because they try to be a project management tool. They aren't. A good tracker answers four questions at a glance: what needs doing, who owns it, when it's due, and whether it's done. That's it.

Six columns. Resist the urge to add a "project phase" dropdown or a color-coded department tag on day one. If a spreadsheet needs a legend to be readable, it needs fewer columns instead.

Here's what one filled row looks like once the sheet is live: "Send revised budget to finance" / Rafael / 2026-07-21 / Open / High / "Waiting on Q3 actuals from ops first." Nothing clever, but every column earns its place, and anyone opening the file cold understands the state of that item in about two seconds.

Skip the Notes column and you'll regret it inside a month. It's the one field that turns "still open" from a mystery into an answer. Without it, someone always has to ping the owner to ask what's actually going on, which defeats the point of having a shared tracker in the first place.

Turn checkboxes into your status column

Skip a text dropdown for the "Done" state and use a real checkbox instead. It's faster to click, and it plays nicely with formulas because a checked box evaluates to TRUE (or 1) and an unchecked one evaluates to FALSE (or 0).

In Google Sheets: select the range, then Insert > Checkbox. Checked = TRUE, unchecked = FALSE, by default.

In Excel (365): select the range, go to Insert > Checkbox (native checkboxes shipped in 2024; older versions need a Developer-tab form control instead). Checked = TRUE, unchecked = FALSE, same as Sheets.

Once the checkbox exists, add a strikethrough for anything marked done. In both apps: select your action item column, open conditional formatting, choose "custom formula," and enter:

=$D2=TRUE

(assuming column D holds the checkbox). Apply strikethrough as the format. Done items visibly cross themselves off. Nobody has to delete a row to know it's handled.

Hand checking a checkbox on a laptop action items tracker

If you want the mechanics behind why this works, Exceljet's guide to native checkboxes in Excel walks through the TRUE/FALSE logic in more depth than most tutorials bother with.

Checkboxes also happen to be the fastest input on a phone. Tapping a small square beats opening a dropdown and scrolling to "Done" every time, which matters more than it sounds like it should when half your team is updating the tracker between meetings, standing up, phone in hand.

How many action items is too many for one person

A tracker doesn't fix a workload problem, it just makes the workload problem visible faster. If one owner shows up next to twelve rows after a single meeting, the sheet isn't broken; the meeting was.

A ratio worth borrowing from project managers who've run this experiment for years: roughly 20% of active action items marked High priority, 60% Medium, 20% Low. If every row in your Priority column says High, the column has stopped meaning anything, and people start ignoring it entirely, including the genuinely urgent ones.

The same logic applies per person. Two to three substantial action items per owner, per meeting, is a realistic ceiling. Past that number, items don't get skipped randomly, they get skipped by whoever shouts loudest in the next meeting, which is a worse way to prioritize than any spreadsheet formula.

If your Priority column has drifted to mostly High, that's a signal to reset it in the next meeting rather than a signal to add a fourth priority tier. Sit down, rank the open rows against each other honestly, and demote everything that isn't actually blocking something else. The formula stays the same either way; it's the discipline around filling in that column that decides whether the tracker means anything six weeks from now.

The formula that turns overdue items red without you touching a thing

This is the one formula worth memorizing. It highlights an entire row when the due date has passed and the status isn't "Done":

=AND($C2<TODAY(), $D2<>TRUE)

Column C is the due date, column D is the checkbox. Select your data range, open conditional formatting, use a custom formula, paste the line above, and set the fill to red.

The logic is simple once you see it: TODAY() recalculates every time the sheet opens, so "overdue" is never a stale label someone forgot to update. It's just true or false, checked live. AND() makes sure a completed item never turns red just because its due date has passed. That distinction is the difference between a tracker people trust and one they start ignoring by week three.

For the mechanics of writing formulas like this one, Exceljet's piece on conditional formatting with formulas is worth the ten minutes if you want to build your own variations later.

Worth noting: if your action items already come out of a recorded meeting, some notetakers (Fathom included) generate a first-draft action item list on their own. You're not typing from memory, you're copying and formatting.

Counting what's actually done (without opening the sheet)

Add a small summary block above your table, three cells wide, no chart needed yet:

=COUNTIF(D2:D200,TRUE)
=COUNTIF(D2:D200,FALSE)
=COUNTIFS(D2:D200,FALSE,C2:C200,"<"&TODAY())

That's completed count, open count, and overdue count, in that order. Pin them at the top of the sheet (row 1) with bold labels, and anyone glancing at the file for two seconds gets the state of the world without scrolling.

One caveat that trips people up in Excel specifically: if you're using native checkboxes on a version older than 365, the cell might store "Yes"/"No" text instead of TRUE/FALSE by default. Check what your checkbox actually writes before copy-pasting the formulas above. A quick way to verify: click an empty cell, type =D2, and see what comes back.

Want the numbers to update live without reopening the file? Pin those three summary cells with Freeze Panes (View > Freeze > First row, in both apps), so the count stays visible while the actual rows scroll underneath. It sounds minor, but it's the difference between a tracker someone checks once a week and one that's open in a tab all day.

Where the action items come from before they hit your sheet

Most action items start in a meeting, get scribbled in a notes app, and lose half their detail by the time they reach a spreadsheet. AI meeting notetakers exist specifically to skip that step: they listen to the call and generate a structured action item list with owner and context already attached.

Fireflies works well if your team already lives in Zoom or Google Meet and wants action items synced straight into a CRM. It's built for sales and ops teams that need conversation history searchable later, not just a summary.

tl;dv leans toward multi-meeting search: useful if "what did we decide about this three meetings ago" comes up more often than "what's due this week." Either tool exports cleanly enough to paste straight into the six-column tracker above.

Empty meeting room with a laptop showing an action items dashboard

Skip the AI notetaker if your meetings are small and infrequent. Typing four action items by hand takes less time than setting up a bot, and a small team doesn't need conversation intelligence it will never look at again.

Excel or Sheets: does it change how you track this?

Not much, for this specific use case. The checkbox mechanics, the TODAY() logic, and the COUNTIF formulas all behave the same in both apps once you know where the menus live.

The one place it genuinely matters: if your team checks off action items from their phones between meetings, Sheets handles that better today. If the tracker lives inside a larger financial model already built in Excel, keep it there. Don't rebuild a perfectly good workbook in a different app just for this.

One version note worth flagging before you copy any formula from this page: teams still running Excel 2016 or 2019 won't have native checkboxes at all, and TODAY() and COUNTIFS behave identically across every version, so only the checkbox step needs a workaround (the Developer-tab form control mentioned above). Nothing else in this tracker depends on a 365-only feature.

Golden retriever looking at a laptop screen on a home office desk

Should you build this yourself or let Biscuit fetch the formula?

Building the tracker above takes about ten minutes once you've done it once. Copy the six columns, paste the two conditional formatting formulas, add the three COUNTIF cells, and you have a working system that updates itself every time someone checks a box.

Worth building it yourself if you want it to match an existing sheet's formatting, or if you're the kind of person who wants to understand exactly why the red highlight fires. Worth grabbing a pre-built template instead if you just need something working before your next meeting starts in twenty minutes.

Either way, the formulas don't change. Biscuit has already fetched every variation of AND(due date, TODAY()) and COUNTIFS you're likely to need. If your version looks different from what's above, tell him what's in your columns and he'll bring back the exact syntax for it.

Frequently asked questions

What's the best way to track action items in Excel?
Use a six-column table (action item, owner, due date, status, priority, notes), a native checkbox for the status column, and one conditional formatting formula that turns a row red when the due date has passed and the box isn't checked.
How do I make a checklist in Google Sheets with checkboxes?
Select the range you want, then go to Insert > Checkbox. Each checked box evaluates to TRUE and each unchecked box to FALSE, which you can reference directly in COUNTIF or conditional formatting formulas.
What formula highlights overdue action items automatically?
In conditional formatting, use a custom formula like =AND($C2<TODAY(), $D2<>TRUE), where column C holds the due date and column D holds the checkbox. It recalculates every time the sheet opens, so overdue items are never a stale manual label.
How many action items should one person have per meeting?
Two to three substantial items per owner is a realistic ceiling. Past that, items stop getting done in priority order and start getting done in whatever order gets shouted about loudest in the next meeting.
Can AI meeting notetakers generate action items automatically?
Yes. Tools like Fathom and Fireflies AI transcribe a call and output a structured action item list with owner and context already attached, which you can copy straight into a spreadsheet tracker instead of typing from memory.
What's the difference between an action item and a task?
An action item usually comes out of a specific meeting or decision and has an implied deadline tied to that context. A task can exist independently of any meeting. In practice, most action item trackers just need an owner and a due date to function well regardless of the label.
Should I use Excel or Google Sheets for a shared action items tracker?
Google Sheets is generally easier for real-time shared editing and mobile checkbox tapping. Excel makes sense if the tracker needs to live inside a larger workbook or financial model that's already built there. The checkbox and formula logic works identically in both.