ADHD Task & Habit Tracker for Google Sheets

Hey folks, it's Ren here.

Last Tuesday I sat down at my desk, opened the laptop, and counted nineteen browser tabs already waiting for me. A half-written email. Two articles I meant to read. A spreadsheet I had opened on Sunday and not touched since.

I knew exactly what I needed to do that day. I just could not find the start of it under all that noise.

That is the ADHD tax in one screen. Not a lack of effort, a lack of a clear surface to work from.

The thing that finally cleared it was not another app. It was a plain ADHD task tracker in Google Sheets, set up so it only ever shows me what matters today.

"Your mind is for having ideas, not holding them." — David Allen

🧠 Why the to-do app stops working by Thursday

Most task apps are built for a brain that opens them on purpose. They assume you will check the app, trust the list, and work down it.

An ADHD brain does something else. It downloads the app on Monday, files everything beautifully, then forgets the app exists by Thursday.

Please do not be hard on yourself if you have a graveyard of half-used productivity apps. The app was working against the way your attention actually moves.

The usual reasons they fall over:

• The full list loads every time you open it, so you see forty tasks and freeze.
• Notifications pile up, you mute them, and the whole app goes quiet along with them.
• An unfinished task either nags in red or vanishes, and neither one helps.
• The app lives behind an icon you have to remember to tap in the first place.

📊 What a Google Sheets tracker gives you instead

A spreadsheet is boring in the best possible way. It opens to exactly what you left, it never redesigns itself overnight, and you can bend it to your brain in about twenty minutes.

The one change that does the heavy lifting is a filter. You keep every task in the sheet, but you set the view to show only the handful due today.

This is the bit most guides skip. The problem was never the length of your list. It was seeing all of it at once.

Filter the view down to three rows and the same overwhelming backlog becomes something you can actually start. Nothing is deleted. The other tasks are still there, just out of sight until their day comes.

And when a task does not get done, it does not punish you. It quietly carries forward to tomorrow. No broken streak, no red warning. You are far more likely to reopen a sheet that has never once made you feel behind.

🔕 The reason a sheet beats an app: it never pings you

Here is the part almost nobody says out loud. The thing that makes a Google Sheet work for an ADHD brain is that it does not notify you at all.

Every habit app eventually nags. Streak about to break. You missed three tasks. The first few times you feel the jolt and act on it. Then you mute it, and a muted app is a dead app.

A sheet just waits. It is there when you open it and silent when you do not.

For a brain that has muted every notification it was ever sent, that silence is the feature, not the gap.

🛠️ How to build it in Google Sheets

Twenty minutes, one tab, no add-ons. Here is the whole thing.

1. Make five columns. Task, Due, Done, Carry, Notes. That is the entire structure and you will not need more.
2. Put a checkbox in the Done column. Insert, then Checkbox. Ticking a real box gives a small hit of done that a typed x never will.
3. Turn on a Today filter. Create a filter view that shows only rows due today and save it as Today, so it is one tap from the toolbar.
4. Add a fade rule. Use conditional formatting to grey out any row where Done is ticked. Finished work softens instead of cluttering.
5. Open it from your phone. Star the file in the Google Sheets app so it opens in two taps. No reminders, no badge, just the list when you choose to look.

The same five columns track habits too. Add a row for each daily habit, tick the box when it is done, and you have a task and habit tracker living in one Google Sheet.

Run it for a week before you tweak anything. The shape only proves itself once you have opened it on a bad day and found it still made sense.

⚠️ Mistakes to sidestep

• Showing the whole list every time. Fix it: build the Today filter first, before you add a single task.
• Deleting unfinished tasks to feel tidy. Fix it: let them carry forward instead, so nothing is lost and nothing shames you.
• Switching phone reminders on. Fix it: leave them off. The silence is the thing that keeps you coming back.
• Rebuilding the sheet every week. Fix it: pick a layout, use it for a fortnight, and resist redecorating instead of working.

If you want the full version of this system, with the weekly view and a long backlog handled properly, the ADHD task tracker spreadsheet guide walks through the whole setup step by step.

🎯 Your action steps this week

• Open a blank Google Sheet and add the five columns above.
• Put a checkbox in the Done column and tick one thing today, just to feel it.
• Build the Today filter view and save it. This is the step that does the work.
• Add a conditional-formatting rule to fade finished rows.
• If repeating habits are your real sticking point, the ADHD habit tracker spreadsheet guide is the companion to this one.

❓ Frequently asked questions

How do I make an ADHD task tracker in Google Sheets?

Open a blank sheet and add five columns: Task, Due, Done, Carry and Notes. Put a real checkbox in the Done column, then create a saved filter view that shows only rows due today. Add a conditional-formatting rule to fade completed rows. The whole build takes about twenty minutes and needs no add-ons.

Is Google Sheets good for ADHD?

It suits a lot of ADHD adults better than dedicated apps, for one quiet reason: it never notifies you. There is no streak to break and no badge to mute. It opens to exactly what you left, holds everything outside your head, and waits silently until you choose to look. That predictability is what makes it easy to keep using.

Can I track habits in the same Google Sheet?

Yes, and you should. Add one row per daily habit and tick the same kind of checkbox when it is done. Keeping tasks and habits in a single tab means one file to open instead of two, which matters a great deal when remembering to open anything is the hard part.

Why does a spreadsheet work better than an app for ADHD?

Apps tend to nag, then get muted, then get ignored. A spreadsheet does the opposite. It filters down to just today so you are not overwhelmed, it carries unfinished tasks forward without shame, and it makes no sound at all. For a brain that has switched off every alert it has ever received, silent and predictable beats clever every time.

That Tuesday desk still collects nineteen tabs some mornings. The difference now is that I have one calm screen I can switch to, and it only ever asks me for the next three things.

To one clear screen at a time,
Ren

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.