Google Sheets connection in Tableau - Cell-by-Cell Formula Trace

Sample Data

Sample sales data stored in a Google Sheet with dates and sales amounts.

Cell	Value
A1	Date
B1	Sales
A2	2024-01-01
B2	100
A3	2024-01-02
B3	150
A4	2024-01-03
B4	200

Formula Trace

SUM([Sales])

Step 1: Retrieve Sales column values from Google Sheets: [100, 150, 200]

Step 2: SUM([100, 150, 200])

Cell Reference Map

    A       B
1 | Date  | Sales |
2 | 2024-01-01 | 100  |
3 | 2024-01-02 | 150  |
4 | 2024-01-03 | 200  |

The formula references the Sales column (B2:B4) in the Google Sheet.

Result

    A       B       C
1 | Date  | Sales | Total Sales |
2 | 2024-01-01 | 100  | 450         |
3 | 2024-01-02 | 150  |             |
4 | 2024-01-03 | 200  |             |

The Total Sales measure shows the sum of all sales from the Google Sheet data.

Sheet Trace Quiz - 3 Questions

What values does Tableau retrieve from the Google Sheet for the Sales column?

A [100, 150]

B [100, 150, 200]

C [2024-01-01, 2024-01-02, 2024-01-03]

D [200, 300, 400]

Key Result

SUM aggregates numeric values from a connected data source column.