Record meeting outcomes and track action items with automated follow-up reminders
✓ Free to download · ✓ Excel 2016+ and Google Sheets · ✓ Custom version in 24h
Meeting notes are only worth writing if the actions can be found afterwards. This template separates discussion from decisions and actions, so actions are a filterable table rather than a sentence buried in a paragraph.
The actual columns, with sample rows
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| 1 | Meeting | Date | Action | Owner | Due | Status |
| 2 | Weekly ops | 2026-07-07 | Renegotiate DPD rates | M. Ferrer | 2026-07-21 | Open |
| 3 | Weekly ops | 2026-07-07 | Publish Q3 targets | A. Duval | 2026-07-14 | Done |
| 4 | Board | 2026-07-09 | Draft hiring plan | K. Owens | 2026-07-31 | Open |
| 5 | Weekly ops | 2026-07-14 | Add size chart to PDP | S. Novak | 2026-07-28 | Open |
Why each one is written the way it is
=IF(AND([@Status]<>"Done",[@Due]<TODAY()),"OVERDUE",[@Status])
Status that reflects reality. An action marked Open and three weeks past due should not look the same as one due next month.
=COUNTIFS(Actions[Owner],[@Owner],Actions[Status],"Open")
Open actions per person, which is the number to read out at the start of the next meeting.
=COUNTIFS(Actions[Meeting],[@Meeting],Actions[Status],"Done")/COUNTIFS(Actions[Meeting],[@Meeting])
Completion rate per recurring meeting. A meeting whose actions are consistently unfinished is a meeting with a problem.
=TEXTJOIN("; ",TRUE,IF(Actions[Meeting]=[@Meeting],Actions[Action],""))
All actions from one meeting as a single string, for pasting into a follow-up email.
A worked example with real numbers
A weekly operations meeting kept revisiting the same three items. Extracting actions into one table showed a 41% completion rate and, more tellingly, four actions raised twice under different wording. Reading open actions at the start rather than the end of the meeting moved completion above 80% within a month.
Tab by tab
| Tab | Contents |
|---|---|
| Meetings | Date, attendees, agenda and discussion notes. |
| Actions | Every action across every meeting, with owner and due date. |
| Decisions | Decisions recorded separately from discussion. |
| Dashboard | Open actions by owner and completion rate by meeting. |
| README | The rule: an action needs an owner and a date or it is not an action. |
What is included, and what to look at next
Specific to this workbook, not generic
Because they are read at different times. A decision is looked up months later to answer "why did we do it this way"; an action is checked next week. Mixed together, neither is findable.
Rarely. Nobody rereads them. Spend the effort on the decision and action rows, which are the parts with a future audience.
In Google Sheets, an Apps Script trigger can email owners with open actions each Monday. That is a short automation.
"This meeting tracker has revolutionized how we manage our meetings. The automated action item tracking and reminders ensure nothing falls through the cracks."