Multi-brand design systems in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows design tokens for three different brands in a multi-brand design system: brand names, their primary and secondary colors, and their fonts.

Cell	Value
A1	Brand
B1	Primary Color
C1	Secondary Color
D1	Font
A2	Brand A
B2	#FF5733
C2	#C70039
D2	Roboto
A3	Brand B
B3	#3355FF
C3	#33A1FF
D3	Open Sans
A4	Brand C
B4	#33FF57
C4	#39C700
D4	Lato

Formula Trace

FILTER(Table, Table[Brand] = "Brand B")

Step 1: Table[Brand]

Step 2: Table[Brand] = "Brand B"

Step 3: FILTER(Table, [FALSE, TRUE, FALSE])

Cell Reference Map

    A        B           C           D
1 | Brand | Primary  | Secondary | Font    |
2 | Brand A | #FF5733 | #C70039  | Roboto  |
3 | Brand B | #3355FF | #33A1FF  | Open Sans |
4 | Brand C | #33FF57 | #39C700  | Lato    |

Filter references column A (Brand) to find 'Brand B'.

The formula filters the table by checking the Brand column (A2:A4) for 'Brand B'.

Result

    A        B           C           D
3 | Brand B | #3355FF | #33A1FF  | Open Sans |

The filtered result shows only the row for Brand B with its design tokens.

Sheet Trace Quiz - 3 Questions

Which row does the filter formula return?

A Row 3 with Brand B

B Row 2 with Brand A

C Row 4 with Brand C

D All rows

Key Result

FILTER returns rows where a condition on a column is TRUE, selecting specific brand data.