0
0
Figmabi_tool~10 mins

Real-time multiplayer editing in Figma - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
Sample Data

This data shows a log of user actions in a real-time multiplayer editing session in Figma, with timestamps.

CellValue
A1User
B1Action
C1Timestamp
A2Alice
B2Added Shape
C210:00:01
A3Bob
B3Moved Shape
C310:00:03
A4Alice
B4Changed Color
C410:00:05
A5Charlie
B5Deleted Shape
C510:00:07
Formula Trace
COUNTIF(A2:A5, "Alice")
Step 1: Range A2:A5 values = ["Alice", "Bob", "Alice", "Charlie"]
Step 2: Check each value if it equals "Alice"
Step 3: Count TRUE values in the list
Cell Reference Map
    A       B             C
1 | User  | Action      | Timestamp
2 | Alice | Added Shape | 10:00:01
3 | Bob   | Moved Shape | 10:00:03
4 | Alice | Changed Color | 10:00:05
5 | Charlie | Deleted Shape | 10:00:07

Formula references cells A2 to A5 to count occurrences of "Alice".
The formula counts how many times 'Alice' appears in the User column from A2 to A5.
Result
    A       B             C
1 | User  | Action      | Timestamp
2 | Alice | Added Shape | 10:00:01
3 | Bob   | Moved Shape | 10:00:03
4 | Alice | Changed Color | 10:00:05
5 | Charlie | Deleted Shape | 10:00:07

Result cell (e.g., D1): 2
The result shows that Alice performed 2 actions in the editing session.
Sheet Trace Quiz - 3 Questions
Test your understanding
How many actions did Alice perform according to the formula?
A3
B1
C2
D4
Key Result
COUNTIF(range, criteria) counts how many cells in the range meet the criteria.