Why efficient workflows save time in Figma - Formula Trace Breakdown

Sample Data

This data shows different tasks in a workflow, the time each task takes, how many times it is done, and a column to calculate total time spent per task.

Cell	Value
A1	Task
B1	Time per Task (minutes)
C1	Number of Tasks
D1	Total Time (minutes)
A2	Design Mockup
B2	30
C2	3
D2
A3	Review
B3	15
C3	4
D3
A4	Feedback Incorporation
B4	20
C4	2
D4
A5	Total Time
B5
C5
D5

Formula Trace

=B2*C2 + B3*C3 + B4*C4

Step 1: B2 * C2

Step 2: B3 * C3

Step 3: B4 * C4

Step 4: 90 + 60 + 40

Cell Reference Map

    A           B           C           D
1 | Task      | Time/Task | # Tasks  | Total Time
2 | Design    |    30     |    3     |          
3 | Review    |    15     |    4     |          
4 | Feedback  |    20     |    2     |          
5 | Total     |           |          |          

Arrows: B2->B2*C2, C2->B2*C2, B3->B3*C3, C3->B3*C3, B4->B4*C4, C4->B4*C4, all sums to final total

Cells B2, C2, B3, C3, B4, and C4 are referenced to calculate total time spent on all tasks.

Result

    A           B           C           D
1 | Task      | Time/Task | # Tasks  | Total Time
2 | Design    |    30     |    3     |    90    
3 | Review    |    15     |    4     |    60    
4 | Feedback  |    20     |    2     |    40    
5 | Total     |           |          |   190    

Column D shows total time per task (time per task multiplied by number of tasks). Cell D5 shows the sum of all total times, representing total workflow time.

Sheet Trace Quiz - 3 Questions

What is the total time spent on the 'Review' task?

A 60 minutes

B 15 minutes

C 4 minutes

D 90 minutes

Key Result

Sum of products: multiply each task's time by its count, then add all results