Most people who want to build a dashboard in Google Sheets start by staring at a blank tab. That is the hard way. The fast way is to copy a layout that already works, then swap in your own data.

Below are 10 dashboard examples that cover the situations people actually build for: sales, marketing, finance, ecommerce, projects, agencies, inventory, recruiting, and a one-screen executive summary. For each one you get what it shows, the metric that matters, and the formula pattern that powers it. Steal the structure. The formulas are the same three or four ideas reused over and over.

What every good dashboard has in common

Before the examples, the shape. Almost every dashboard worth copying follows the same four-part structure:

  • KPI tiles up top. Three to six big numbers that answer "is this good or bad?" at a glance.
  • A trend below. One or two charts showing where those numbers are heading over time.
  • Detail at the bottom. A sorted or filtered table for the person who wants to dig in.
  • Raw data on its own tab. The dashboard tab never holds raw rows. It reads from a clean data tab so you can refresh without breaking the layout.

Keep that separation and almost everything else becomes easy. Now the layouts.

10 dashboard examples

1. Sales dashboard
KPI tiles for revenue, deals closed, and average deal size. A monthly revenue line chart, then a rep leaderboard table. Key metric: revenue versus target. Powered by a SUMIFS that totals a deals tab by month or by rep.
2. Marketing / ROAS dashboard
Tiles for spend, conversions, and cost per acquisition. A channel breakdown table with return on ad spend per channel. Key metric: ROAS, calculated as revenue divided by spend per channel.
3. KPI scorecard
One row per metric: current value, target, and a status pill. No charts, just a clean grid that says green or red. Key metric: percent to target. A simple ratio drives conditional formatting on each row.
4. Finance / cash-flow dashboard
Tiles for cash in, cash out, and net position. A running balance chart and a monthly category table. Key metric: net cash flow. SUMIFS totals transactions by month and by category from a ledger tab.
5. Ecommerce (Shopify) dashboard
Tiles for orders, revenue, and average order value. A daily sales sparkline and a top-products table pulled from an order export. Key metric: average order value, revenue divided by order count.
6. Project / task dashboard
Tiles for tasks open, overdue, and done this week. A status breakdown and an owner table. Key metric: overdue count. COUNTIFS counts tasks where the due date has passed and status is not "Done".
7. Agency client report
One screen per client: traffic, leads, and spend tiles, plus a month-over-month trend. Built once as a template, duplicated per client. Key metric: leads per dollar. A QUERY pulls only that client's rows.
8. Inventory dashboard
Tiles for items in stock, items below reorder point, and total stock value. A reorder table sorted by urgency. Key metric: items below threshold. COUNTIFS flags rows where quantity drops under the reorder level.
9. Recruiting / pipeline dashboard
A funnel of candidates by stage: applied, screened, interviewed, offered, hired. Tiles for active roles and time to hire. Key metric: stage conversion. A QUERY groups candidates by stage and counts them.
10. Executive summary dashboard
One screen pulling the single most important number from every other dashboard: revenue, cash, pipeline, headcount. Sparklines instead of full charts to save space. Key metric: the handful that the CEO checks daily.

The KPI tile formula (SUMIFS)

Nearly every tile in the list above is a SUMIFS or COUNTIFS that totals one column from your data tab against one or two conditions. This is the single most reused pattern in dashboards. Here it totals revenue for the current month from a deals tab:

KPI tile - revenue this month =SUMIFS( Deals!C:C, Deals!A:A, ">="&EOMONTH(TODAY(), -1)+1, Deals!A:A, "<="&EOMONTH(TODAY(), 0) )

Column C holds the deal amount, column A holds the close date. Swap C for a count and you get "deals closed". Add a third condition on the rep column and you get per-rep totals for a leaderboard.

The trend formula (SPARKLINE)

For the trend row, you do not always need a full chart. A SPARKLINE draws a tiny in-cell line or bar that fits right next to a KPI tile, which is exactly what the ecommerce and executive examples use:

In-cell trend =SPARKLINE( B2:M2, {"charttype","line"; "color","#0F9D58"; "linewidth",2} )

Point it at a row of 12 monthly totals and you get a one-cell story of the year. Change "line" to "column" for bars, or "bar" for a single progress-style bar that is great on a scorecard.

The summary table formula (QUERY)

For the detail table at the bottom, and for the client report and recruiting funnel, QUERY does the grouping and sorting in one formula. Here it summarizes total revenue by channel, biggest first, which is the backbone of the marketing dashboard:

Summary by channel =QUERY( Data!A:D, "SELECT B, SUM(D) WHERE B IS NOT NULL GROUP BY B ORDER BY SUM(D) DESC LABEL SUM(D) 'Revenue'", 1)

Column B is the channel, column D is revenue. Change the grouped column to rep, product, stage, or category and the same formula powers the sales leaderboard, the top-products table, or the recruiting funnel.

How to build any of these

Pick the layout closest to your situation, set up a clean data tab, then build the KPI tiles with SUMIFS, the trend with a chart or SPARKLINE, and the detail table with QUERY. That is genuinely the whole job. If you want the full walkthrough from blank sheet to finished screen, read the step-by-step guide.

If you would rather skip the build entirely, that is what we do. We build dashboards in Google Sheets that pull from your existing data and update themselves, so you get the screen without writing a single formula.