Font selection and pairing in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows font names, their styles, and suggested usage for a BI dashboard design.

Cell	Value
A1	Font Name
B1	Font Style
C1	Usage
A2	Roboto
B2	Regular
C2	Body Text
A3	Roboto
B3	Bold
C3	Headings
A4	Montserrat
B4	Regular
C4	Subheadings
A5	Open Sans
B5	Italic
C5	Quotes

Formula Trace

SELECT fonts WHERE usage IN ('Headings', 'Body Text')

Step 1: Check each row's Usage column for 'Headings' or 'Body Text'

Step 2: Extract Font Name and Font Style from matched rows

Step 3: Pair fonts for dashboard text elements

Cell Reference Map

   A          B           C
1 |Font Name |Font Style |Usage
2 |Roboto    |Regular    |Body Text
3 |Roboto    |Bold       |Headings
4 |Montserrat|Regular    |Subheadings
5 |Open Sans |Italic     |Quotes

The formula references the Usage column (C2:C5) to filter fonts for headings and body text.

Result

   A          B           C
1 |Font Name |Font Style |Usage
2 |Roboto    |Regular    |Body Text
3 |Roboto    |Bold       |Headings

Selected font pairing for dashboard:
- Body Text: Roboto Regular
- Headings: Roboto Bold

The result shows the selected font pairing for the dashboard's body text and headings.

Sheet Trace Quiz - 3 Questions

Which font style is chosen for the dashboard headings?

A Roboto Regular

B Montserrat Regular

C Roboto Bold

D Open Sans Italic

Key Result

Filter rows by Usage column to select fonts for headings and body text.