Why formulas automate calculations in Google Sheets - Dashboard Impact

Dashboard Mode - Why formulas automate calculations

Goal

Understand how formulas in Google Sheets automatically calculate results when data changes.

Sample Data

Item	Price	Quantity	Total Cost
Apples	2	5	=B2*C2
Bananas	1	8	=B3*C3
Oranges	3	4	=B4*C4
Grapes	4	3	=B5*C5
Peaches	2.5	6	=B6*C6

Dashboard Components

• KPI Card: Total Sales with formula =SUM(D2:D6) showing the sum of all total costs.
• Table: Shows Item, Price, Quantity, and Total Cost columns. The Total Cost column uses formulas like =B2*C2 to calculate cost per item automatically.

Dashboard Layout

+----------------------+--------------------+
|      Total Sales      |                    |
|      (KPI Card)       |                    |
+----------------------+    Item Table       |
|                      |  (Data with formulas)|
|                      |                    |
+----------------------+--------------------+

Interactivity

When you change any Price or Quantity value, the Total Cost cells recalculate automatically because of the formulas. The Total Sales KPI updates instantly to reflect the new sum.

Self Check

Try changing the quantity of Apples from 5 to 10. Which components update?

• The Total Cost for Apples updates automatically.
• The Total Sales KPI card updates to show the new total.

Key Result

A simple sales dashboard showing how formulas automatically update calculations when data changes.