Form-like interactions in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows user data with Name, Age, and Country columns.

Cell	Value
A1	Name
B1	Age
C1	Country
A2	Alice
B2	30
C2	USA
A3	Bob
B3	25
C3	Canada
A4	Carol
B4	28
C4	UK

Formula Trace

FILTER(Table1, Table1[Age] > 26)

Step 1: Table1[Age]

Step 2: Table1[Age] > 26

Step 3: FILTER(Table1, [true, false, true])

Cell Reference Map

    A       B       C
1 | Name  | Age   | Country |
2 | Alice | 30    | USA     |
3 | Bob   | 25    | Canada  |
4 | Carol | 28    | UK      |

Arrows: Age column (B2:B4) feeds into FILTER condition

The formula uses the Age column (cells B2 to B4) to filter rows.

Result

    A       B       C
2 | Alice | 30    | USA     |
4 | Carol | 28    | UK      |

The filtered table shows only users older than 26: Alice and Carol.

Sheet Trace Quiz - 3 Questions

Which rows does the FILTER formula keep?

A Rows where Age is less than 26

B All rows

C Rows where Age is greater than 26

D No rows

Key Result

FILTER(table, condition) returns rows where condition is TRUE