Design review workflows in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows design tasks, who they are assigned to, their current review status, and comments from reviewers.

Cell	Value
A1	Design Task
B1	Assigned To
C1	Status
D1	Review Comments
A2	Homepage Redesign
B2	Alice
C2	In Review
D2	Needs better contrast
A3	Login Flow
B3	Bob
C3	Approved
D3	Looks good
A4	Dashboard UI
B4	Charlie
C4	In Review
D4	Add tooltip on icons

Formula Trace

COUNTIF(C2:C4, "In Review")

Step 1: Check C2 value 'In Review' equals 'In Review'

Step 2: Check C3 value 'Approved' equals 'In Review'

Step 3: Check C4 value 'In Review' equals 'In Review'

Step 4: Sum counts: 1 + 0 + 1

Cell Reference Map

    A               B           C           D
1 | Design Task     | Assigned To | Status    | Review Comments
2 | Homepage Redesign | Alice      | In Review | Needs better contrast
3 | Login Flow      | Bob        | Approved  | Looks good
4 | Dashboard UI    | Charlie    | In Review | Add tooltip on icons

Formula references cells C2, C3, C4 for status values.

The formula counts how many tasks have the status 'In Review' by checking cells C2 to C4.

Result

    A               B           C           D
1 | Design Task     | Assigned To | Status    | Review Comments
2 | Homepage Redesign | Alice      | In Review | Needs better contrast
3 | Login Flow      | Bob        | Approved  | Looks good
4 | Dashboard UI    | Charlie    | In Review | Add tooltip on icons

Result cell E1: 2

The result '2' shows there are two design tasks currently in the review phase.

Sheet Trace Quiz - 3 Questions

How many tasks are currently 'In Review'?

A 2

B 3

C 1

D 0

Key Result

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