Update: after more than two years using the solution below, I finally decided to create my own native Android app. Give it a try!
A New Year’s resolution is a tradition in which we make a bunch of promises¹ -on the last days of the year or so- to ourselves to do something in order to improve our behaviour or lifestyle in a good way during the year ahead (i.e. quit smoking, eat less junk food, lose weight, do some form of exercise and/or stop saying JS is a real programming language²).
Even though some they could be just a personal goal or challenge (i.e. travel solo), almost every promise we make of this kind usually is -to a greater or lesser degree- a habit (to either make or break it).
A habit is the behaviour pattern, acquired through frequent repetition³, we do often unconsciously -unintentionally and uncontrollably- in response to a known cue⁴.
Most of us have ever promised to break some bad habit as a New Year’s resolution and then realise after summer holidays -at best- that we hadn’t even started. And then, once again, another year is gone…
I’ve tried a bunch of applications and websites to track habits but for whatever reason (pricing, lack of export options, uncertain future, etc…) I haven’t felt comfortable with any of them. Then, I talked to two huge organisation experts Jesus Cerviño & David.S -whom I’m lucky enough to have as co-workers- and I was told that I could do everything I wanted (and even more) with a powerful tool⁶ widely used: Google Sheets.
Log in to your Google Account, make a copy of my Habit Tracker template (File>Make a copy…) and fill down Activity column with your smart goals and habits.
Then, clear the sample data and you will be able to track your own habits putting a X (or 😄/🙁 depending of your mood) on every cell you want to mark it as Done.
Streak and Max Streak
Progression based on the value you have put in Expected column (which has to be in days⁷)
Highlight current day
Alternate colours every month
Autohide columns based on date
Tip: you could even use the Habit Tracker as a habits related journal through the built-in notes feature.
Don’t forget to set up a recurring reminder (you can use also Google Calendar btw) so you don’t forget to keep track of your habits. Then make a habit of this too!
Above all, don’t be a slave of your (bad) habits… and be like Bill!
This article was originally published on Medium
 The most common New Year’s Resolutions in UK (December 2015) and US (December 2017)
 Just trolling, don’t feed me 🐟
 Developing a new habit takes between 18 and 254 days (66 days on average). Unfortunately, there are no magic numbers.
 A great tip about habits and willpower: we should not focus on the behaviour but rather focus on the cue (i.e. location, time of day, emotional state, belief, other people, etc…) to develop new habits (or to break them)
 What gets measured gets done
 It’s free, multi-platform, allow us to export the data and works offline 💪
 Remember that a common year has 52 weeks (i.e. if you want to workout 3 times a week you just have to put in that cell