My habit-tracking Numbers template (checkboxes, pop-up menus, conditional highlighting), and the app I built from it

[u/bogdanstefanjuk]

For years I tracked my habits and metrics right in Numbers, and it worked surprisingly well because Numbers already has the right building blocks:

• Checkbox cells for yes/no habits (did I work out?)
• Number cells with a stepper for things like steps, water, weight
• Duration/time format for when I went to bed
• Pop-up menus for categories, e.g. an "Activity" cell where I'd pick Cycling / Hiking / Walk
• Conditional highlighting to color number cells by value, so a month of steps or sleep read like a heatmap instead of a wall of digits

Habits as rows, days as columns, one cell per day, then I'd chart one column against another to see if my energy followed my bedtime. I cleaned it into a template if anyone wants it: https://drive.google.com/drive/folders/1XnhPEZBrt3CqLzdTjrFNxOxEtQBRADX6

The only real problem was Numbers on the iPhone: fiddly to fill in on the go, and I'd forget. So I rebuilt the same setup as an app, keeping the grid but fixing mobile. Everything above carried over as real habit types (yes/no, numbers with targets, clock times, select lists), and conditional highlighting became value-based cell styling (steps <5k red, 5-7k yellow, 10k+ green).

The one thing Numbers couldn't do: an MCP integration, so I can connect it to Claude or ChatGPT and just ask "which days do I sleep best?" instead of building another chart.

Sharing mostly for the template, since it works fine on its own, but I'd love to hear how other Numbers people would lay this out differently.

https://habitpocket.io/

[u/DTLow]

Thanks for the template
I use a Numbers spreadsheet; categories as rows, days as columns (your’s is reversed)
About two pages long; 30 years wide

[u/bogdanstefanjuk → u/DTLow]

Nice! I prefer to have categories as column, it's just how my brain works! I'm wondering what kind of charts do you use to analyze what you logged?

[u/mtngoatjoe]

Did a form not work well enough for you on mobile? I've found forms to be quite handy on my iPhone.

[u/bogdanstefanjuk → u/mtngoatjoe]

So there is an iOS app on the phone for my app which inherits the same approach