0
0
Figmabi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

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

CellValue
A1Design Task
B1Assigned To
C1Status
D1Review Comments
A2Homepage Redesign
B2Alice
C2In Review
D2Needs better contrast
A3Login Flow
B3Bob
C3Approved
D3Looks good
A4Dashboard UI
B4Charlie
C4In Review
D4Add 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
Test your understanding
How many tasks are currently 'In Review'?
A2
B3
C1
D0
Key Result
COUNTIF(range, criteria) counts how many cells in the range meet the criteria.