Design sprint workflow in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows the 5-day design sprint workflow steps with their activities and goals.

Cell	Value
A1	Day
B1	Activity
C1	Goal
A2	1
B2	Understand & Map
C2	Define problem and set long-term goal
A3	2
B3	Sketch
C3	Generate solutions and ideas
A4	3
B4	Decide
C4	Choose best ideas to prototype
A5	4
B5	Prototype
C5	Build a realistic prototype
A6	5
B6	Test
C6	Get user feedback and learn

Formula Trace

COUNTIF(B2:B6, "Prototype")

Step 1: Check each cell in B2:B6 if value equals "Prototype"

Step 2: Count TRUE values from step 1

Cell Reference Map

    A       B               C
1 | Day | Activity       | Goal
2 | 1   | Understand & Map | Define problem and set long-term goal
3 | 2   | Sketch         | Generate solutions and ideas
4 | 3   | Decide         | Choose best ideas to prototype
5 | 4   | Prototype      | Build a realistic prototype
6 | 5   | Test           | Get user feedback and learn

Formula references cells B2 to B6 highlighted:

The formula looks at the Activity column from row 2 to 6 to count how many times 'Prototype' appears.

Result

    A       B               C
1 | Day | Activity       | Goal
2 | 1   | Understand & Map | Define problem and set long-term goal
3 | 2   | Sketch         | Generate solutions and ideas
4 | 3   | Decide         | Choose best ideas to prototype
5 | 4   | Prototype      | Build a realistic prototype
6 | 5   | Test           | Get user feedback and learn

Result in cell D1: 1

The formula result is 1 because 'Prototype' appears once in the Activity column.

Sheet Trace Quiz - 3 Questions

How many times does the word 'Prototype' appear in the Activity column?

A 2

B 1

C 3

D 0

Key Result

COUNTIF(range, criteria) counts how many cells in the range meet the criteria.