ADHD Executive Function Tracker That Bridges the Gap

Hey folks, it's Ren here.

The sat-nav rerouted me three times on the drive home from Wollongong last weekend. Roadworks on the M1. A diversion through some industrial estate I had never seen before. Then a second diversion through a third one. Each time the screen calmly redrew the line and said, in that unbothered British voice, recalculating.

I think that voice is what executive function sounds like when it is working.

For an ADHD brain, the voice does not always answer. You miss the exit. The screen freezes. You sit on the shoulder of the road in your head, knowing you need to choose a new route, unable to start.

That stuck moment is not laziness. It is the executive function gap, and a good ADHD executive function tracker is built to catch you in it.

"ADHD is not a disorder of knowing what to do. It is a disorder of doing what you know." — Dr. Russell Barkley

🚦 Why most planners miss the executive function moment

Most planners track outputs. Did the task get done. Did the box get ticked. Did the day end with progress to point at.

Executive function does not live in the output. It lives in the moment just before it, the few seconds between knowing you should start and actually starting. That moment is where ADHD adults get quietly stuck, and almost no tracker is designed to see it.

Please do not be hard on yourself if every productivity tool you have ever tried has failed in that exact gap. The tool was never looking at the right thing.

Here is what trackers usually miss:

  • The transition from "I should" to "I am starting", which is the part that actually breaks.
  • The energy cost of every restart after an interruption, which compounds across the day.
  • The mental rehearsing of a task you have not begun yet, which feels like work but moves nothing.
  • The relief of writing it down so your brain can stop carrying it around.

🧠 EF is a chain, and most trackers measure the wrong link

The trick almost nobody writes about: executive function is not one skill. It is a chain of small ones, fired in sequence, and the chain can break at any link.

Notice the task exists. Hold it in mind long enough to plan. Sequence the steps. Initiate the first one. Sustain attention while doing it. Adjust when something changes. Finish and switch to the next thing. Seven small moves, all dependent on the one before.

The executive function chain: six steps from notice to finish, with one link missing in the middle

When a link breaks, the rest of the chain is fine, but the system stalls. "I cannot start" might really be "I cannot sequence". "I am avoiding it" might really be "I have not yet seen the shape of the task". A tracker that just asks "did you finish?" cannot tell you which link is the problem, so every solution it suggests is generic.

The fix is making each link visible. Not all at once, not in clinical detail, just enough that you can spot the same link breaking on the same kind of task and stop blaming yourself.

⏳ The gap between "I should" and "I am doing"

If the chain has a usual breaking point, this is it. The gap between intent and action is the executive function moment, and for an ADHD brain it can stretch for hours without warning.

The gap between I should and I am doing it - a tangled loop of indecision between intent and action

Track that gap, not the finish. When did the task arrive in your head. When did you actually start it. What did you do in the space between. Most of the time, the answer is "I reorganised my stationery, opened three unrelated tabs, made another coffee, then sat back down." That is data. Watch it for a fortnight and the patterns are quietly obvious.

🛠️ How to set up an ADHD executive function tracker

You can build this in about twenty minutes in Google Sheets or Excel. Five columns is enough.

  1. Task. One row per task. Capture them the second they arrive. The brain dump is the release valve.
  2. Where it usually breaks. A tiny dropdown with the chain stages: notice, plan, sequence, start, sustain, adjust, finish. Tag the link you got stuck on, even after the fact.
  3. Gap minutes. Roughly how long sat between "I should" and "I started". Estimate. The number itself matters less than seeing it on the page.
  4. Energy at start. Low, medium, high. This is the bit that turns the tracker into a pattern-finder.
  5. Outcome. Done, partial, carried forward. No streak counter, no shame column.

Use it for two weeks before you draw any conclusions. The point is not to fix yourself by Friday. It is to externalise the pattern so the chain becomes visible to you the way it has always been visible to your partner.

An external spreadsheet scaffolding holding the executive function chain together from above
All-In-One Task Tracker & Project Planner (Purple) by JRen Digital

An external chain that catches the gap

The All-In-One Task Tracker & Project Planner has the brain dump, energy tags, weekly view and carry-forward built in, so the executive function chain has somewhere to live outside your head. 12 tools in one file, Google Sheets and Excel, one-time purchase. Trusted by over 70,000 customers.

Get the All-In-One Task Tracker →

⚠️ Mistakes to sidestep

  • Tracking the outcome and ignoring the gap. Fix it: log the minutes between "I should" and "I started". The gap is the data.
  • Trying to fix every link of the chain at once. Fix it: pick one link that breaks most often and watch only that for a fortnight.
  • Building a tracker that punishes a slow start. Fix it: a slow start is information, not a failure. No streaks, no shame.
  • Tagging energy at the end of the day from memory. Fix it: tag at the start, when the data is honest. Otherwise the whole sheet drifts.

If you want the broader weekly system this tracker bolts onto, the task tracker spreadsheet guide walks through the wider weekly view that this chain logging sits inside.

🎯 Your action steps this week

  • Open a fresh sheet and lay out the five columns above.
  • For three days, log every task as it lands. No filtering.
  • Tag the gap minutes from memory if you forgot at the start. Honest guesses are fine.
  • On Sunday, scan the "where it broke" column and pick the most common link.
  • If you also need the day-to-day task layer that sits underneath this, the ADHD task tracker spreadsheet guide is the companion to this one.

❓ Frequently asked questions

What is an executive function tracker?

It is a simple log that records not just what you did but where the executive function chain broke. Most trackers ask “did you finish?”. This kind asks “where did you get stuck?” across the chain of noticing, planning, starting, sustaining and finishing. The point is to make the invisible part of ADHD visible so you can spot patterns instead of blaming yourself.

Can a spreadsheet really help with executive function?

Yes, because the core ADHD issue is not effort, it is memory and sequencing. A spreadsheet externalises both. It holds the steps so your brain does not have to, and it lets you see the chain in front of you in a way no app notification can. Many ADHD adults report calmer weeks within a fortnight once the chain is on the screen instead of in their head.

What executive function skills should I track?

The most useful ones for adults are task initiation, working memory, planning and sequencing, sustained attention, and switching. You do not need to track all five at once. Pick the one that breaks first, watch it for a couple of weeks, then add the next one. Trying to track the whole chain on day one almost always collapses the system.

Is this different from a normal task tracker?

Yes, the difference is the gap column. A normal task tracker lists what needs doing. An executive function tracker also records the time between intent and action, the energy at the start, and where the chain stalled. Same task list, more honest data underneath, designed for the ADHD pattern of “knew what to do, did not do it” that a regular tracker never explains.

Sometimes the recalculating voice does answer. The sat-nav redraws the line, you take the new exit, and the day moves. The tracker just makes sure you can see when it was you and when it was the chain breaking quietly underneath.

To a softer reroute when the week wobbles,
Ren

About Ren

Ren is the founder of JRen Digital, home to minimalist budgeting, debt and life-organisation spreadsheets trusted by over 70,000 customers worldwide. Ren writes practical, no-nonsense guides that help everyday people take the stress out of money and time. Explore the full range of templates at jrendigital.com.

This article is for general information only and is not medical or psychological advice. It is not a substitute for guidance from a qualified health professional about ADHD or any health condition.