Component variants in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows button components with their variant states and colors in a design system.

Cell	Value
A1	Button
B1	State
C1	Color
A2	Submit
B2	Default
C2	Blue
A3	Submit
B3	Hover
C3	Light Blue
A4	Submit
B4	Pressed
C4	Dark Blue
A5	Cancel
B5	Default
C5	Gray
A6	Cancel
B6	Hover
C6	Light Gray
A7	Cancel
B7	Pressed
C7	Dark Gray

Formula Trace

SELECT Color FROM Components WHERE Button = 'Submit' AND State = 'Hover'

Step 1: Filter Components where Button = 'Submit'

Step 2: Filter previous result where State = 'Hover'

Step 3: Select Color from filtered row

Cell Reference Map

    A       B        C
1 |Button | State  | Color
2 |Submit | Default| Blue
3 |Submit | Hover  | Light Blue
4 |Submit | Pressed| Dark Blue
5 |Cancel | Default| Gray
6 |Cancel | Hover  | Light Gray
7 |Cancel | Pressed| Dark Gray

The formula references the Button and State columns to find the matching Color.

Result

    D
1 |Result
2 |Light Blue

The result cell shows the color 'Light Blue' for the Submit button in Hover state.

Sheet Trace Quiz - 3 Questions

Which rows are selected after filtering Button = 'Submit'?

A Rows 2, 3, 4

B Rows 5, 6, 7

C Rows 1, 2, 3

D Rows 3, 4, 5

Key Result

Filter rows by multiple conditions then select a column value