0
0
Figmabi_tool~10 mins

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

Choose your learning style9 modes available
Sample Data

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

CellValue
A1Design Element
B1Status
C1Comments
A2Homepage Banner
B2In Review
C2Needs brighter colors for better visibility.
A3Signup Button
B3Approved
C3Looks good, no changes needed.
A4Footer Links
B4In Review
C4Add 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
Test your understanding
How many design elements are currently 'In Review'?
A1
B3
C2
D0
Key Result
COUNTIF(range, criteria) counts how many cells in the range meet the criteria.