Multi-step flows in Figma - Cell-by-Cell Formula Trace

Sample Data

This data represents a multi-step user flow in an app, showing each step number, the action taken, and the current status of that step.

Cell	Value
A1	Step
B1	Action
C1	Status
A2	1
B2	Login
C2	Completed
A3	2
B3	Select Product
C3	Completed
A4	3
B4	Add to Cart
C4	Pending
A5	4
B5	Checkout
C5	Pending

Formula Trace

IF(C2="Completed", IF(C3="Completed", IF(C4="Completed", "Flow Complete", "Step 3 Pending"), "Step 2 Pending"), "Step 1 Pending")

Step 1: C2="Completed"

Step 2: C3="Completed"

Step 3: C4="Completed"

Step 4: IF(C4="Completed", "Flow Complete", "Step 3 Pending")

Step 5: IF(C3="Completed", IF(C4="Completed", "Flow Complete", "Step 3 Pending"), "Step 2 Pending")

Step 6: IF(C2="Completed", IF(C3="Completed", IF(C4="Completed", "Flow Complete", "Step 3 Pending"), "Step 2 Pending"), "Step 1 Pending")

Cell Reference Map

    A       B             C
1 | Step | Action      | Status    |
2 | 1    | Login       | Completed |
3 | 2    | Select Product | Completed |
4 | 3    | Add to Cart | Pending   |
5 | 4    | Checkout    | Pending   |

References: C2, C3, C4

The formula checks the status cells C2, C3, and C4 to decide which step is pending or if the flow is complete.

Result

    A       B             C             D
1 | Step | Action      | Status    | Flow Status   |
2 | 1    | Login       | Completed | Step 3 Pending|
3 | 2    | Select Product | Completed |              |
4 | 3    | Add to Cart | Pending   |              |
5 | 4    | Checkout    | Pending   |              |

The formula result 'Step 3 Pending' is shown in column D for the first row, indicating the current flow status based on step completions.

Sheet Trace Quiz - 3 Questions

What does the formula check first?

A If Step 3 is completed

B If Step 1 is completed

C If Step 4 is completed

D If Step 2 is completed

Key Result

Nested IF statements check each step's status in order to determine the current flow progress.