This guide will explain how to create a habit tracker in Google Sheets.
Table of Contents
Habit trackers are a great way to record your progress in developing a particular habit. They serve as a powerful visual reminders of your goals and inspire you to stay on track.
While there are numerous third-party applications available for habit tracking, you can implement one yourself in Google Sheets for free. Creating a habit tracker in Google Sheets also provides additional flexibility on what your tracker can do.
In this guide, we will provide a step-by-step tutorial on how to create a habit tracker in Google Sheets. We will cover how to set up a monthly habit tracker, including flexible date and day of the week headers for better navigation.
A Real Example of a Habit Tracker in Google Sheets
Let’s explore a sample sheet with a working habit tracker in Google Sheets.
In the sheet above, we have an empty habit tracker template. The template can support tracking up to 10 habits for an entire month.
The user only needs to fill out cells A3:A12 with the different habits they want to track. After filling out the habits, the user can then specify the current month in cell A1. The tracker is equipped custom formulas to automatically update the column headers with the right dates and days of the week.
In the sheet above, we have a habit tracker for the month of December. We were able to keep track of five different habits in a convenient table.
To fill out the dates of our habit tracker, we’ll use the following formula:
SEQUENCE function allows us to output an array of sequential numbers. The first argument is the number of rows to return, and the second argument is the number of columns to return. For example, the formula SEQUENCE(1,30) will return a single row with numbers from 1 through 30.
However, since the number of days in a year could vary, we’ll use the
DAY function in our formula to return the last day of the month.
To fill out the days of the week in our habit tracker, we’ll use the following formula:
This formula appends the number of the column in row 1 with the month provided in cell A1. Using the
TEXT function, we then convert it to the shortened day of the week (Mon, Tue, and so on). Since the
TEXT function does not accept arrays as arguments, we’ll need to wrap it with an Array Formula function to output an array.
Click on the link below to create your own copy of our examples.
Head to the next section to read our step-by-step tutorial on how to create your own habit tracker in Google Sheets.
How to Create a Habit Tracker in Google Sheets
- We can start our habit tracker by formatting the initial table. We’ll need a cell that specifies the current month and a range where we’ll list all the habits we’re tracking.
In our habit tracker, each day of the month is given its own column, and each habit is given a row.
- To better navigate the tracker, we’ll label each column with the corresponding day of the month it’s tracking.
In the example above, we used the formula =SEQUENCE(1,DAY(EOMONTH(A1&1, 0))) in cell B1 to generate a sequence of numbers starting from 1 up to the last day of the indicated month.
- We’ll create an ArrayFormula that uses the
TEXTfunction to return the appropriate day of the week for each day in our habit tracker.
In our example, we’ll use the formula =SEQUENCE(1,DAY(EOMONTH(A1&1, 0))) to generate the days of the week for our habit tracker.
- Next, we’ll select the range of cells we want to add checkboxes to.
To add checkboxes to the selection, click Insert > Checkbox.
The selected range should now be populated with unchecked checkboxes.
- To use the habit tracker, simply use your cursor to check all the habits you’ve observed or completed during the day.
When you’ve completed an entire month, you can create a copy of this sheet and replace the month name in cell A1 to ensure that the number of days and days of the week is updated for the current month.
These are all the steps you need to follow to create your own habit tracker in Google Sheets.
- How can I share my habit tracker with others for collaborative tracking?
You can share your habit tracker by clicking on the ‘Share’ button in the top right corner of Google Sheets. You can then add the email addresses of the people you want to share with and set their permissions to either viewer, commenter, or editor, depending on how you want them to interact with the tracker.
- Can I set up notifications to remind me to fill in my habit tracker?
Google Sheets does not have a built-in reminder function, but you can set up notifications using Google Calendar. Alternatively, you can find a third-party service to send email reminders to fill out your habit tracker sheet.
To learn more about other use cases in Google Sheets for checkboxes, you can read our post on how to create an order tracker sheet. You may also be interested in our guide on how to highlight a cell or row with a checkbox.
That’s all for this guide! Be sure to check out our library of spreadsheet resources, tips, and tricks!