Build a Dashboard Tab That Actually Runs Your Week (Not Just Decorates Your Spreadsheet)

Turn a single Google Sheets tab into a working dashboard that shows what's due, what's stuck, and what needs you. Step-by-step setup for any industry.

You open your spreadsheet Monday morning and you've got seven tabs. Clients. Invoices. Inventory. Tasks. Projects. A tab called 'misc' that you're afraid to look at. Another one called 'Sheet4' that could be anything. You click through each one, scanning rows, trying to piece together what's on fire this week. By the time you've built a mental picture of your workload, it's 9:45 and you haven't actually done anything yet.

I ran this exact drill for about two years — freelance production work, juggling a dozen active jobs across multiple sheets — before a friend who manages a landscaping crew showed me his setup. He had one tab at the front of his workbook called 'This Week.' It pulled in overdue invoices, upcoming jobs, and flagged anything missing a signed contract. It wasn't fancy. It looked like a spreadsheet, not a magazine cover. But he opened it every morning and knew exactly what to do first. That's a dashboard. Not a chart with gradients. A tab that runs your week.

Why Most Dashboard Tabs Fail (And What Actually Works)

The word 'dashboard' makes people reach for pie charts and sparklines. That's fine if you're presenting quarterly numbers to a board. But if you're a solo operator or a small team trying to not drop balls, a dashboard is something much simpler: it's a single view that answers your three daily questions. What's overdue? What's due soon? What's stuck waiting on someone else?

Most dashboard tabs fail because they try to summarize everything. They end up as a wall of COUNTIFs and charts that nobody updates and nobody reads. The ones that survive are narrow. They pull from your existing tabs using simple formulas, they highlight the stuff that needs action, and they stay out of the way for everything else.

Here's the principle I follow now: if a dashboard cell doesn't change what I do today, it doesn't belong on the dashboard. My 'total projects completed this quarter' number? Interesting, but it can live somewhere else. My 'invoices overdue by more than 7 days' count? That changes my morning.

Step 1: Set Up Your Three Zones

Create a new tab and name it something you'll actually click — 'This Week,' 'HQ,' 'Cockpit,' whatever. I've seen people call it '⚡ Dashboard' so the emoji catches their eye in the tab bar. (Silly? Maybe. Effective? Yes.) Structure the tab into three horizontal zones, each with a header row.

• 🔴 OVERDUE / NEEDS ACTION — anything past its due date or flagged as blocked
• 🟡 COMING UP — tasks, invoices, jobs, or deadlines in the next 7 days
• 📊 QUICK COUNTS — 3–5 numbers that tell you the health of your operation at a glance

That's it. Three zones. The red zone is what you look at first. The yellow zone is what you plan around. The counts zone is a sanity check — how many open projects, unpaid invoices, items missing a file or signature. Everything else stays on its own tab.

Step 2: Pull Overdue Items Automatically with FILTER

The FILTER function is the backbone of a working dashboard. It grabs rows from another tab based on conditions you set, and it updates live. No copy-pasting. No remembering to refresh. Here's the formula I use in cell A3 of my dashboard to pull every overdue task from my 'Tasks' tab:

This says: grab columns A through E from the Tasks tab, but only rows where the date in column D is before today AND the status in column E isn't 'Done.' If nothing matches, show a friendly message instead of an error. Adjust the column references to match your layout — column D might be your due date, column E your status. The logic is the same whether you're tracking client sessions, repair jobs, or translation projects.

For the 'Coming Up' zone, the formula is almost identical — just change the date condition:

Now you've got a live view of everything due in the next seven days. Change the 7 to 14 or 3 depending on how far ahead you plan. I use 7 for tasks and 14 for invoices, because chasing payment always takes longer than you think.

Step 3: Build Your Quick Counts

Below the two action zones, I keep a small grid — usually 2 columns, 4–5 rows. Column A is the label, Column B is the number. These are the vital signs of your operation. Here are the ones I've found useful across very different types of work:

• Open projects: =COUNTIF(Projects!F2:F, "<>Done")
• Invoices unpaid: =COUNTIFS(Invoices!E2:E, "Sent", Invoices!F2:F, "")
• Tasks overdue: =COUNTIFS(Tasks!D2:D, "<"&TODAY(), Tasks!E2:E, "<>Done")
• Items missing a file/attachment: =COUNTIF(Projects!G2:G, "")
• Revenue collected this month: =SUMPRODUCT((MONTH(Invoices!D2:D)=MONTH(TODAY()))*(Invoices!F2:F))

Pick the 4–5 that matter to YOUR work and ignore the rest. A photographer might care about 'shoots this month with no contract attached.' An HVAC tech might care about 'service calls scheduled with no equipment notes.' A therapist might track 'clients with expired intake forms.' The formula structure is the same — COUNTIF, COUNTIFS, SUMPRODUCT — you just point them at different columns.

Step 4: Add Conditional Formatting So Problems Shout at You

A dashboard only works if the urgent stuff is visually obvious when you glance at it. You shouldn't have to read every cell — the colors should tell you where to look. Here's my go-to conditional formatting setup for the quick counts zone:

• Select the cell with your 'Tasks overdue' count.
• Go to Format → Conditional formatting.
• Set the rule: 'Is greater than' → 0 → format with red background, white bold text.
• Add a second rule: 'Is equal to' → 0 → format with green background.
• Repeat for your 'Invoices unpaid' and 'Missing file' counts.

Now when you open the dashboard, a red cell means something needs attention. Green means you're clear. You process this in about half a second — faster than reading a number and deciding if it's bad. I also apply conditional formatting to the FILTER results in the overdue zone: any row where the date is more than 3 days past due gets a red highlight. That way I can see the difference between 'due yesterday' and 'due two weeks ago and I completely forgot.'

Use that as a custom formula rule applied to the entire overdue results range. It catches rows where the due date is more than 3 days in the past and the task still isn't done.

Step 5: Make It Your Default Landing Spot

A dashboard nobody opens is just decoration. Drag the tab to the leftmost position in your workbook so it's the first thing you see when you open the file. If you share the workbook with a team, pin a note at the top of the dashboard: 'Start here every morning. Update your status columns in the other tabs. This tab reads from those automatically.'

The key behavioral shift is this: stop opening individual tabs to figure out your day. Open the dashboard. Let the dashboard tell you which tab to go to. That's the difference between scanning seven tabs for 15 minutes and getting your bearings in 30 seconds. It's a small structural change that saves real time — not hours, but the kind of scattered, anxious tab-hopping that eats your focus before you've started real work.

Real Examples Across Different Work

I've helped a few people set this up now, and the dashboard looks different for each person — but the structure is always the same three zones. A wedding planner I know pulls 'upcoming weddings in the next 14 days' and 'vendors with unsigned contracts' into her dashboard. A contractor friend pulls 'jobs missing inspection photos' and 'invoices over $1,000 unpaid.' I pull 'deliverables due this week' and 'projects waiting on client feedback.'

The 'missing file' count is the one that surprises people the most. A veterinary clinic admin told me she added a count of patient records with no vaccination certificate attached. The number was 34. She'd been assuming it was maybe 5 or 6. That one COUNTIF uncovered a real operational hole. If you use FileFox or any method to attach files to your spreadsheet rows, pointing a COUNTBLANK or COUNTIF at that column is probably the highest-value formula on your dashboard.

The One Thing to Do First

Don't try to build the whole dashboard in one sitting. Open your most important workbook right now, add a blank tab, drag it to position one, and name it 'This Week.' Then write one FILTER formula that pulls your overdue items. Just the overdue items. Live with that for a few days. You'll immediately notice what else you want to see — and more importantly, you'll stop opening five tabs to figure out what's late. The yellow zone and the counts can come next week. Start with the red zone. That's where the relief is.

Frequently Asked Questions

Can I build a Google Sheets dashboard that pulls from multiple spreadsheets, not just multiple tabs?

Yes, use IMPORTRANGE to pull data from other spreadsheets into a hidden tab in your dashboard workbook, then use FILTER on that imported data. The syntax is =IMPORTRANGE("spreadsheet_url", "Sheet1!A1:E100"). You'll need to authorize the connection the first time. Keep in mind that IMPORTRANGE can be slow if you're pulling thousands of rows.

How do I stop my FILTER formula from showing a #N/A error when there are no results?

Wrap the FILTER in IFERROR. For example: =IFERROR(FILTER(Tasks!A2:E, Tasks!D2:D < TODAY()), "Nothing to show"). The second argument is the message displayed when no rows match your criteria. This keeps your dashboard clean instead of showing a red error cell.

What's the difference between a dashboard tab and a summary report in Google Sheets?

A summary report is backward-looking — it tells you what happened (total sales, completed projects, hours logged). A dashboard tab is forward-looking — it tells you what needs to happen next (overdue tasks, upcoming deadlines, missing files). You might eventually want both, but the dashboard is what you open every morning.

How many quick count metrics should I put on my dashboard tab?

Keep it between 3 and 6. More than that and you stop actually reading them. Pick metrics that change what you do — 'overdue invoices' is actionable, 'total clients all time' is not. If a number doesn't make you want to click into another tab and fix something, it doesn't earn dashboard space.

Will my dashboard slow down my spreadsheet if I have a lot of data?

FILTER and COUNTIF formulas are relatively lightweight, but if you're working with 10,000+ rows across multiple tabs, you may notice lag. The fix is to limit your FILTER ranges to only the rows you actually use (e.g., A2:E500 instead of A2:E) and avoid volatile functions like NOW() in multiple cells. For most small-business workbooks under a few thousand rows, performance is fine.