Comments and feedback in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows design elements with their review status and feedback comments from the team.

Cell	Value
A1	Design Element
B1	Status
C1	Comments
A2	Homepage Banner
B2	In Review
C2	Needs brighter colors for better visibility.
A3	Signup Button
B3	Approved
C3	Looks good, no changes needed.
A4	Footer Links
B4	In Review
C4	Add social media icons.

Formula Trace

COUNTIF(B2:B4, "In Review")

Step 1: Range B2:B4 values = ["In Review", "Approved", "In Review"]

Step 2: Check each value if it equals "In Review"

Step 3: Count TRUE values

Cell Reference Map

    A           B           C
1 | Design Element | Status    | Comments
2 | Homepage Banner| In Review | Needs brighter colors for better visibility.
3 | Signup Button  | Approved  | Looks good, no changes needed.
4 | Footer Links   | In Review | Add social media icons.

The formula references the Status column cells B2 to B4 to count how many are 'In Review'.

Result

    A           B           C
1 | Design Element | Status    | Comments
2 | Homepage Banner| In Review | Needs brighter colors for better visibility.
3 | Signup Button  | Approved  | Looks good, no changes needed.
4 | Footer Links   | In Review | Add social media icons.
5 |               |           | 
6 | Total In Review: 2

The result '2' shows the count of design elements currently marked as 'In Review' in the Status column.

Sheet Trace Quiz - 3 Questions

How many design elements are currently 'In Review'?

A 1

B 3

C 2

D 0

Key Result

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