AutoFill for formula copying in Google Sheets - Dashboard Guide

Dashboard Mode - AutoFill for formula copying

Goal

Calculate total sales for each product by copying a formula down the column automatically.

Sample Data

Product	Price	Quantity Sold	Total Sales
Apples	2	30
Bananas	1	50
Cherries	3	20
Dates	5	10
Elderberries	4	15

Dashboard Components

• KPI Card: Total Revenue calculated with formula =SUM(D2:D6) showing total sales of all products.
• Data Table: Shows products with columns for Price, Quantity Sold, and Total Sales.
• Formula in Total Sales Column: In cell D2 enter =B2*C2 and use AutoFill to copy this formula down to D3:D6. This calculates total sales per product.

Dashboard Layout

+----------------------+------------------+
|      Data Table       |   Total Revenue  |
|  (Products & Sales)   |     (KPI Card)   |
+----------------------+------------------+

Interactivity

When you update Price or Quantity Sold for any product, the Total Sales column updates automatically because the formula is copied down using AutoFill. The Total Revenue KPI card also updates to reflect the new total.

Self Check

If you change the Quantity Sold for Bananas from 50 to 60, which cells update and what is the new Total Revenue?

Answer: Cell D3 updates to =B3*C3 = 1*60 = 60. The Total Revenue cell updates to sum all Total Sales: 2*30 + 60 + 3*20 + 5*10 + 4*15 = 60 + 60 + 60 + 50 + 60 = 290.

Key Result

Dashboard shows product sales with AutoFill formula calculating total sales and a KPI card summing total revenue.