0
0
Figmabi_tool~10 mins

Fixed elements in prototypes in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This table shows UI elements in a prototype with their screen positions and whether they are fixed (stay visible when scrolling).

CellValue
A1Element
B1Position
C1Fixed
A2Header
B2Top
C2Yes
A3Sidebar
B3Left
C3No
A4Footer
B4Bottom
C4Yes
A5Content
B5Center
C5No
Formula Trace
COUNTIF(C2:C5, "Yes")
Step 1: C2:C5 values = ["Yes", "No", "Yes", "No"]
Step 2: COUNTIF(C2:C5, "Yes") counts how many cells equal "Yes"
Cell Reference Map
    A       B       C
1 |Element|Position|Fixed |
2 |Header |Top     |Yes   |
3 |Sidebar|Left    |No    |
4 |Footer |Bottom  |Yes   |
5 |Content|Center  |No    |
The formula references cells C2 to C5 to check which elements are fixed.
Result
    A       B       C       D
1 |Element|Position|Fixed |Count Fixed|
2 |Header |Top     |Yes   |          |
3 |Sidebar|Left    |No    |          |
4 |Footer |Bottom  |Yes   |          |
5 |Content|Center  |No    |          |
6 |       |        |      |2         |
The count of fixed elements (2) is shown in cell D6, summarizing how many UI parts stay visible when scrolling.
Sheet Trace Quiz - 3 Questions
Test your understanding
How many elements are fixed in the prototype?
A1
B2
C3
D4
Key Result
COUNTIF(range, "Yes") counts how many cells in the range have the value "Yes".