Why real-time collaboration improves workflow in Figma - Formula Trace Breakdown

Sample Data

This table shows tasks in a project with their current status, who is assigned, and comments. It represents a typical workflow in a team.

Cell	Value
A1	Task
B1	Status
C1	Assigned To
D1	Comments
A2	Design Homepage
B2	In Progress
C2	Alice
D2	Waiting for feedback
A3	Write Content
B3	Not Started
C3	Bob
D3
A4	Review SEO
B4	Completed
C4	Charlie
D4	Approved by manager

Formula Trace

COUNTIF(B2:B4, "In Progress") + COUNTIF(B2:B4, "Not Started")

Step 1: COUNTIF(B2:B4, "In Progress")

Step 2: COUNTIF(B2:B4, "Not Started")

Step 3: 1 + 1

Cell Reference Map

    A           B             C           D
1 | Task      | Status      | Assigned To | Comments
2 | Design Homepage | In Progress | Alice      | Waiting for feedback
3 | Write Content   | Not Started | Bob        | 
4 | Review SEO      | Completed   | Charlie    | Approved by manager

Arrows: B2:B4 cells are referenced for status counts.

The formula looks at the Status column (cells B2 to B4) to count tasks by their current state.

Result

    A           B             C           D
1 | Task      | Status      | Assigned To | Comments
2 | Design Homepage | In Progress | Alice      | Waiting for feedback
3 | Write Content   | Not Started | Bob        | 
4 | Review SEO      | Completed   | Charlie    | Approved by manager

Result cell (E1): 2

The result '2' shows the number of tasks that are either in progress or not started, indicating active workflow items.

Sheet Trace Quiz - 3 Questions

How many tasks are currently 'In Progress' according to the formula?

A 2

B 1

C 0

D 3

Key Result

COUNTIF(range, condition) counts cells matching condition; adding counts sums multiple conditions.