IMPORTRANGE for other spreadsheets in Google Sheets - Dashboard Guide

Dashboard Mode - IMPORTRANGE for other spreadsheets

Goal

See sales data from another Google Sheet in this dashboard to track monthly sales across regions.

Sample Data

Data is imported from another spreadsheet showing monthly sales by region.

Month	Region	Sales
January	East	1000
January	West	1500
February	East	1200
February	West	1300
March	East	1100
March	West	1400

Dashboard Components

• Imported Sales Data Table: Uses =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456/edit#gid=0", "Sheet1!A2:C7") to bring in sales data from another spreadsheet.
• Total Sales KPI: Calculates total sales with =SUM(C2:C7) from the imported data.
• Average Sales per Month: Uses =AVERAGE(C2:C7) to find average sales.
• Sales by Region Table: Uses =QUERY(A2:C7, "select B, sum(C) group by B", 0) to sum sales by region.

Dashboard Layout

+---------------------------+-----------------------+
| Imported Sales Data Table  | Total Sales KPI       |
| (Full data from IMPORTRANGE) | (Sum of Sales)       |
+---------------------------+-----------------------+
| Sales by Region Table      | Average Sales per Month|
| (Sum sales by region)     | (Average sales)        |
+---------------------------+-----------------------+

Interactivity

Add a filter dropdown for Month. When you select a month, all components update to show data only for that month. The IMPORTRANGE data is filtered using formulas like =FILTER(IMPORTRANGE(...), INDEX(IMPORTRANGE(...),0,1)=selectedMonth).

Self Check

If you add a filter for Month = February, which components update?

• Imported Sales Data Table shows only February rows.
• Total Sales KPI updates to sum February sales only.
• Average Sales per Month updates to average February sales.
• Sales by Region Table shows sales sums for February only.

Key Result

Dashboard imports sales data from another Google Sheet and shows total, average, and sales by region with month filtering.