How to Create a Weekly Tracker in Google Sheets

Building a weekly tracker in Google Sheets is a simple yet powerful way to stay on top of your goals, tasks, or business metrics. Whether you're tracking project progress, weekly sales numbers, or your own habits, a well-structured sheet can provide a clear view of your week at a glance. This guide will walk you through creating one step-by-step, from a basic manual layout to a more automated and visual dashboard.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Build a Simple Weekly Tracker from Scratch

The easiest way to start is by creating a simple, manual tracker. This method doesn't require any complex formulas and can be set up in just a few minutes. It’s perfect for tracking tasks, content publishing schedules, or daily checklists.

1. Set Up Your Sheet

Start with a blank Google Sheet. The first thing you'll want to do is give your tracker a clear structure. A common layout involves listing your tasks or metrics down the first column and the days of the week across the top row.

• In cell A2, type a heading like "Task" or "Metric."
• In cell B1, type "Monday."
• Click on cell B1 and drag the small blue square (the fill handle) at the bottom-right corner of the cell across to cell H1. Google Sheets will automatically fill in the days of the week for you, from Monday to Sunday.

2. Add Your Tasks or Metrics

Starting in cell A3, list all the items you want to track for the week. This could be anything from "Publish blog post" and "Update CRM" to "Daily Sales" and "New Leads." Don't worry about getting the list perfect, you can always add or remove items later.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

3. Use Checkboxes for Easy Tracking

Checkboxes are one of the most satisfying ways to track task completion. They provide a clear, visual way to see what's done and what's left.

To add checkboxes:

• Select the entire range where you'll want to mark tasks complete (e.g., from cell B3 down and across to H10, or however large your task area is).
• Go to the menu and click Insert > Checkbox.

Now, you can simply click a box to mark a task as complete for a specific day. At this stage, you have a fully functional manual tracker! It’s simple, intuitive, and effective for many use cases.

Upgrade Your Tracker with Google Sheets Formulas

While a manual tracker is great, a few simple formulas can add a layer of automation that saves time and surfaces valuable insights. You can add a summary section to see your progress at a glance.

Automate Progress with COUNTIF

Manually counting completed tasks is tedious. The COUNTIF formula can do it for you. We can use it to create a "Tasks Completed" column that automatically updates as you check off items.

Let's add two new columns: "Total Tasks" and "% Complete".

• In cell I1, type "Tasks Completed."
• In cell J1, type "Percentage."
• In cell I3, enter the following formula:

=COUNTIF(B3:H3, TRUE)

This formula counts the number of checkboxes that are checked (which have a value of TRUE) in the range B3 to H3. Drag the fill handle down from cell I3 to apply this formula to all your task rows.

To calculate the completion percentage, enter this formula in cell J3:

=I3 / 7

Then, click on column J, go to Format > Number > Percent to format the result as a percentage. Drag this formula down as well.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Visualize Progress with a Sparkline Bar

Percentages are good, but a visual progress bar is even better. The SPARKLINE function is a great way to create simple, in-cell charts.

• In the newly created column K1, type the header "Progress Bar."
• In cell K3, paste the following formula:

=SPARKLINE(J3, {"charttype","bar","max",1,"color1","#4CAF50"})

• J3: This is the cell containing the percentage we want to visualize.
• "charttype","bar": This tells Google Sheets we want a bar chart.
• "max",1: Since percentages are decimals between 0 and 1, we set the maximum value to 1 (which equals 100%).
• "color1","#4CAF50": This sets the bar color to a nice green. Feel free to change the hex code to your preferred color.

Drag this formula down, and you’ll have a clean, dynamic progress bar for each task.

Use SUM for Metric Tracking

If you're tracking numbers instead of tasks (like sales, hours worked, or articles written), you can use the SUM formula to get weekly totals.

Simply replace the checkboxes with number inputs for each day. Then, in your summary column (e.g., column I), use this formula:

=SUM(B3:H3)

This will give you the total for each metric across the entire week.

Use Conditional Formatting to Bring Your Tracker to Life

Conditional formatting changes a cell's appearance based on specific rules, making it much easier to spot trends, completed items, or areas that need attention. Here are a couple of useful ways to apply it to your weekly tracker.

Highlight Completed Rows

A satisfying way to acknowledge a finished task is to have the entire row change color when it's 100% complete.

• Select your entire data range, from the first task name to the last progress bar (e.g., A3:K10).
• Go to Format > Conditional formatting. A sidebar will appear on the right.
• Under "Format rules," choose "Custom formula is" from the dropdown menu.
• In the value box that appears, enter the following formula:

=$J3=1

The dollar sign $ before the J is important - it tells Google Sheets to always look at the percentage in column J, even as it applies the format across the other columns in the row.

Under "Formatting style," choose a fill color (like a light green) and you can even apply strikethrough text for extra visual confirmation.

Click "Done."

Now, whenever a task's progress hits 100%, the entire row will automatically format itself.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Color-Code Metric Performance

If you're tracking metrics, you can use color scales to instantly see high and low performers.

• Select the cells containing your numerical data (e.g., B3:H10).
• Go to Format > Conditional formatting.
• Click the "Color scale" tab at the top of the sidebar.
• You can choose a preset color scale (like green for high values and red for low values). Google Sheets will automatically apply a gradient, making it easy to identify the best and worst performing days or metrics at a glance.

Turn Your Tracker into a Reusable Template

Once you’ve perfected your weekly tracker, the last thing you want to do is rebuild it every week. Turning it into a template is simple and will save you tons of time.

1. Finalize Your Design: Make any final tweaks to the formatting, formulas, and layout until you’re happy with it.
2. Create a "Template" Sheet: Rename the current sheet to something like "Weekly Tracker Template."
3. Clear Out the Data: Delete all the specific data for the week - uncheck all the boxes or clear out the numerical metrics. Your formulas and progress bars should reset to zero.
4. Duplicate for Each New Week: Whenever you need to start a new week, simply right-click the "Weekly Tracker Template" tab at the bottom of the screen and select "Duplicate." Rename the new copy to the date range for that week (e.g., "Oct 28 - Nov 3"), and you're ready to go.

This process gives you a clean, fresh tracker for every week without having to rebuild anything.

Final Thoughts

By following these steps, you can create a customized and effective weekly tracker in Google Sheets tailored perfectly to your needs. Starting with a basic layout and layering on automation with functional formulas and compelling visuals transforms a simple spreadsheet into a genuine productivity tool.

While Google Sheets is perfect for this kind of DIY tracking, we know that integrating data from other apps - like your sales from Shopify, ad spend from Facebook, or traffic from Google Analytics - still requires manual exporting and copy-pasting. That’s why we built Graphed. We connect directly to your data sources so you can simply ask, "create a dashboard showing my weekly ad spend vs. sales," and get a live, automated report in seconds, with no setup required.