How to Create a Yes No Tracker in Google Sheets

A simple Yes/No tracker in Google Sheets can be a surprisingly powerful tool for organizing everything from project tasks and event checklists to daily habits. Forget complex project management software, sometimes, all you need is a clear visual way to see what's done and what isn't. This article walks you through several ways to create a functional and great-looking Yes/No tracker, from a basic checkbox list to a more dynamic dashboard with progress bars.

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

The Easiest Method: Checkboxes and COUNTIF

The simplest and quickest way to track a "yes" or "no" status is with checkboxes. They are interactive, satisfying to click, and easy to count. A checked box represents "Yes" (TRUE), and an unchecked box represents "No" (FALSE).

Step 1: Set Up Your Columns

Start with a clean Google Sheet. Create two columns. The first one will be for your list of items (e.g., "Tasks," "Habits," "Action Items"). The second will be for the status (e.g., "Done?," "Completed?").

Your sheet should look like this:

• Column A: Task
• Column B: Completed?

Step 2: Insert Checkboxes

Now, let's add the checkboxes to your second column.

1. Highlight the cells where you want the checkboxes to appear (e.g., B2 through B10).
2. Go to the menu and click Insert > Checkbox.

Your cells will instantly populate with clickable checkboxes. When you check a box, its underlying value in the cell becomes TRUE. When it’s unchecked, the value is FALSE. You won't see the words "TRUE" or "FALSE," just the box, but knowing this is crucial for the next step.

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

Step 3: Count Your "Yes" and "No" Responses

Tracking is pointless without summarizing the results. Let's create a small summary section at the top of your sheet to count the completed and pending items. Find a couple of empty cells, maybe D2 and E2, and label them "Completed (Yes)" and "Pending (No)."

We’ll use the COUNTIF function, which counts cells in a range that meet a specific criterion.

To count the "Yes" (checked) boxes:

In the cell next to your "Completed (Yes)" label, enter this formula:

=COUNTIF(B2:B10, TRUE)

This formula scans the range B2:B10 and counts every cell where the checkbox is checked (i.e., has a value of TRUE).

To count the "No" (unchecked) boxes:

In the cell next to your "Pending (No)" label, enter this formula:

=COUNTIF(B2:B10, FALSE)

This formula does the opposite, counting every unchecked box (with a value of FALSE).

Now, whenever you check or uncheck a box, your summary totals will update in real time. This basic setup is all you need for a functional tracker.

Add Visual Impact with Conditional Formatting

A functional tracker is good, but a visually intuitive one is better. Conditional formatting changes a cell's appearance based on its value. We can use this to automatically cross out tasks or change their color when you check "Yes."

Step 1: Select the Cells to Format

Highlight the range of cells you want to change visually. A common use is to format the task descriptions in Column A based on the checkbox status in Column B. So, highlight a range like A2:B10 to apply the formatting to the entire row.

Step 2: Create a Custom Formatting Rule

1. With your cells highlighted, go to the menu and click Format > Conditional formatting.
2. A sidebar will appear. Under "Format cells if," change the dropdown from "Format cells if..." to "Custom formula is".
3. In the value/formula box, type the following formula:

Let's break that formula down:

• $B2: The $ before the 'B' fixes the column reference, so the condition always looks at column B regardless of the row. The 2 lock-in the starting row.
• =TRUE: The condition triggers when the checkbox in column B of the respective row is checked.

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

Step 3: Choose Your Formatting Style

Under "Formatting style," you can now design what happens when a task is completed. Good options include:

• Choosing a strikethrough for the text.
• Changing the text color to a light gray.
• Setting the cell's background fill to a light green.

Click "Done." Now, when you check a box in column B, the entire row will automatically format itself, giving you immediate visual confirmation that the item is complete.

Alternative Method: Using Data Validation for Drop-Downs

Checkboxes are great, but sometimes you might prefer a classic "Yes" or "No" in a drop-down menu. This can feel more formal or be a better choice if you might eventually add a third option, like "N/A." You can achieve this using data validation.

Step 1: Set Up Data Validation

1. Highlight the cells where you want the drop-down list to appear (e.g., B2:B10).
2. Go to the menu and click Data > Data validation.
3. In the pop-up window, click "+ Add rule."
4. Under "Criteria," select "Dropdown."
5. For "Option 1," type "Yes." For "Option 2," type "No." You can assign colors to each option here as well, which is a nice visual touch.
6. Click "Done."

Now your selected cells have a small arrow. Clicking on it gives you the choice between "Yes" and "No."

Step 2: Update the COUNTIF Formula

Since the cells no longer contain TRUE/FALSE values, your original COUNTIF formulas won't work. You'll need to update them to count the text-based responses "Yes" and "No."

To count the "Yes" responses:

=COUNTIF(B2:B10, "Yes")

To count the "No" responses:

=COUNTIF(B2:B10, "No")

The core logic is the same, but the criteria now look for a specific text string instead of a boolean value.

Create a Progress Bar for a Dashboard Feel

For a final touch, you can add a progress bar that visualizes your completion rate. This is perfect for motivation and at-a-glance reports. We'll use the powerful but simple SPARKLINE function.

Step 1: Calculate the Completion Percentage

First, you need to calculate what percentage of your tasks are "Yes." In an empty cell (say, D5), let's calculate this value.

1. Count the total number of tasks using COUNTA. This formula counts all non-empty cells in a range. Put this in a helper cell, maybe F1:
2. Count the number of "Yes" responses using your COUNTIF formula from before. Let's say that's in cell D2:
3. Divide the "Yes" count by the total count to get the percentage. In cell D5, enter:

Format this cell as a percentage (Format > Number > Percent).

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

Step 2: Generate the Progress Bar with SPARKLINE

Now for the fun part. The SPARKLINE function lets you create miniature charts inside a single cell. We'll use it to create a bar chart based on our percentage.

In the cell next to your percentage (e.g., E5), enter this formula:

=SPARKLINE(D5, {"charttype","bar","max",1,"color1","green"})

Here's what each part does:

• D5: The cell containing the percentage value.
• {"charttype","bar"}: Specifies a bar chart.
• {"max",1}: Sets the maximum value of the bar to 1 (100%).
• {"color1","green"}: Sets the bar color to green. You can customize this color.

You now have a clean, satisfying progress bar that fills up as you check off your tasks, giving your simple tracker a professional dashboard feel.

Final Thoughts

With checkboxes, conditional formatting, and a simple SPARKLINE function, you can turn a basic Google Sheet into a powerful personal or team tracker. Whether you're monitoring habits, managing project tasks, or planning an event, these tools allow you to create a customized solution that keeps you organized and motivated.

While Google Sheets is fantastic for manual tracking, we know most of your business's "Yes" or "No" questions—like "Did we hit our sales target?" or "Is this ad campaign profitable?"—depend on data from multiple platforms. Pulling that data from Salesforce, Shopify, or Google Analytics often means juggling endless CSVs and manual reports. We built Graphed to solve this by connecting all your data sources automatically and letting you build dashboards using plain English. Instead of building manual trackers cell by cell, you can ask Graphed to "show me a dashboard of my sales team's closed deals vs. goals for this quarter," and it builds a live dashboard instantly, saving you from the work of gathering and updating the data yourself.