How to Create a Daily Tracker in Google Sheets

Building a custom daily tracker to monitor your habits, tasks, or business metrics is a fantastic way to stay accountable and visualize your progress. Instead of relying on a rigid app, Google Sheets gives you a free, flexible canvas to create exactly what you need. This guide will walk you through setting up a powerful and automated daily tracker, from the basic structure to insightful charts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Google Sheets for Your Daily Tracker?

Dedicated tracking apps can be great, but they often come with limitations. Either they're too simple, too complex, too expensive, or just not quite right for what you want to track. Google Sheets hits the sweet spot for a few key reasons:

• It's Completely Customizable: You decide what to track and how to display it. Monitor your sales calls, workouts, content published, or daily water intake - all in one place.
• It's Free and Accessible: All you need is a Google account. You can access and update your tracker from your computer, tablet, or phone.
• It's Collaborative: Easily share your tracker with a coach, business partner, or team members to keep everyone on the same page.
• It Automates the Tedious Parts: With a few simple formulas, you can eliminate the need to manually enter dates or calculate your progress, saving you time and effort.

Step 1: Setting Up the Basic Structure

First, let's build the foundation of your tracker. Open a new Google Sheet and create the columns that will organize your data. Keep it simple to start, you can always add more complexity later.

For this example, we’ll create a tracker for a small business owner who wants to monitor key daily activities.

Set up your headers in the first row like this:

• Column A: Date
• Column B: Day of the Week
• Column C: Sent 5 Outreach Emails
• Column D: Published Social Post
• Column E: Completed 1 Sales Call
• Column F: Notes

Your sheet should look clean and simple. You can freeze the top row to keep your headers visible as you scroll down by navigating to View > Freeze > 1 row.

Step 2: Automating Dates and Days of the Week

Manually typing in the date and day every single day is a chore nobody needs. This is where the magic of spreadsheets comes in. Let’s automate it so you only have to set it up once.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Automate the Dates

In cell A2, type your starting date (e.g., "1/1/2024"). Then, in the cell directly below it, A3, enter this simple formula:

=A2+1

Hit enter. Google Sheets will automatically recognize this as the next calendar day. Now, click on cell A3, and you'll see a small blue square in the bottom-right corner. This is called the "fill handle." Click and drag it down as far as you want - for a month, a quarter, or the entire year - and the dates will populate automatically.

Automate the Day of the Week

Next to your first date in cell B2, we'll use the TEXT formula to automatically pull the day of the week. This saves you from having to check a calendar.

In cell B2, enter this formula:

=TEXT(A2, "dddd")

This formula tells Google Sheets to look at the date in cell A2 and display it as the full name of the day ("Monday"). If you wanted a three-letter abbreviation (like "Mon"), you would use "ddd" instead. Just like with the date, click the fill handle on cell B2 and drag it down to apply the formula to all of your dates.

Step 3: Using Checkboxes for Easy Tracking

Checkboxes are one of the most satisfying ways to mark a task as complete. They are also incredibly useful from a data standpoint. When a checkbox is checked, Google Sheets assigns it a value of TRUE. When it's unchecked, its value is FALSE. We'll use this later to calculate progress.

To add checkboxes:

1. Highlight all the cells where you want to track your habits. In our example, that's columns C through E, from row 2 down to the last date.
2. Navigate to the menu and click Insert > Checkbox.

That's it! Your tracker columns are now filled with checkboxes, ready for you to start ticking things off each day.

Step 4: Calculating Progress and Adding Visuals

Simply tracking tasks is good, but seeing your consistency is what drives motivation. Let's add a few more formulas and some conditional formatting to bring your tracker to life.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Add a Daily Completion Percentage

Create a new column header in G1 called "Daily Progress." In cell G2, we'll use the COUNTIF and COUNTA functions to calculate how many of your daily tasks you completed.

Enter this formula in cell G2:

=COUNTIF(C2:E2, TRUE) / COUNTA($C$1:$E$1)

Let’s break that down:

• COUNTIF(C2:E2, TRUE) counts the number of checked boxes (the ones with a value of TRUE) in that row.
• COUNTA($C$1:$E$1) counts the number of task headers you have. We use the dollar signs ($) to create an absolute reference, so it always refers to the headers in row 1, even when you drag the formula down.
• By dividing the two, you get the percentage of tasks completed for that day.

After entering the formula, format the column as a percentage by selecting column G and navigating to Format > Number > Percent. Then, drag the fill handle down to apply the formula to all your rows.

Use Conditional Formatting to Visualize Progress

Now, let's add some color to make your progress instantly clear. We can use conditional formatting to change the color of the "Daily Progress" cell based on its value.

1. Select the "Daily Progress" column (column G).
2. Go to Format > Conditional formatting.
3. Under the "Format rules" section, select "Color scale."
4. You can choose a default scale, like red-to-green. This will automatically color your cells, making successful days stand out and showing you at a glance which days you fell behind.

You can also apply conditional formatting to the checkboxes themselves. For example, you can set a rule to make the entire row turn light green once all checkboxes are checked.

Step 5: Create a Simple Dashboard with Charts

A day-by-day view is great, but a high-level summary helps you see the bigger picture. Creating a small dashboard area at the top or in a separate tab is a great way to do this.

On your sheet, find some empty space to the side or create a new "Dashboard" tab. We can build a summary of total completed tasks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Summarize Your Totals

Let's create a summary table that shows how many times you completed each task over the entire period. In your dashboard area, list your habits again:

• Sent 5 Outreach Emails
• Published Social Post
• Completed 1 Sales Call

Next to the first task, use the COUNTIF formula to count every checked box in its respective column. If your "Sent 5 Outreach Emails" checkboxes are in column C, the formula would be:

=COUNTIF(Sheet1!C:C, TRUE)

Do this for each task. Now you have a simple summary of your total accomplishments.

Add a Chart for a Quick Visual

Charts make data easy to digest. Let's turn that summary table into a bar chart:

1. Highlight your summary table (both the task names and their totals).
2. Go to Insert > Chart.
3. Google Sheets will usually recommend a good chart type, but a Column or Bar chart works perfectly for this kind of comparison.
4. Customize the colors and titles to make it your own.

This simple chart gives you a quick, visual comparison of where you're putting your effort and which daily habits are the most consistent.

Tips for Making Your Tracker Stick

A tracker is only useful if you use it. Here are a few tips to help you build the habit of tracking:

• Start Small: Don't try to track 20 different things from day one. Start with 3-5 of the most important metrics or habits. You can always add more later.
• Keep it Visible: Bookmark your tracker in your browser. Set it as your homepage or keep the tab open so you're reminded to fill it out each day.
• Use the "Notes" Column: The 'Notes' column is perfect for adding context. Why did you have a great day? Why did you miss a task? Noting things like "Client emergency" or "Felt super motivated" can reveal valuable patterns over time.
• Review Your Progress: Set aside 15 minutes each week to look over your tracker. What’s working? Where are you struggling? Use the insights to adjust your goals and strategy for the week ahead.

Final Thoughts

Building a daily tracker in Google Sheets puts you in control, giving you a custom tool to monitor everything from personal habits to business KPIs. By setting up the basic columns, automating dates with formulas, and visualizing your progress with charts, you can turn a simple spreadsheet into a powerful accountability partner.

As you get more comfortable, you might find yourself pulling results from other platforms into your sheets - like ad spend from Facebook, website traffic from Google Analytics, or sales data from your CRM. That manual reporting is exactly what we built Graphed to remove. We connect to all your data sources automatically, so you can build live charts and dashboards just by describing what you want to see. This frees you from constant spreadsheet updates so you can focus on the insights that drive real growth.