Batch operations and selection in Figma - Cell-by-Cell Formula Trace

Sample Data

This table shows reports with their current status. We want to select multiple pending reports to update their status at once.

Cell	Value
A1	Item
B1	Status
A2	Report1
B2	Pending
A3	Report2
B3	Pending
A4	Report3
B4	Completed
A5	Report4
B5	Pending

Formula Trace

Batch update status to 'Completed' for selected items where Status = 'Pending'

Step 1: Identify rows where Status = 'Pending'

Step 2: Select rows 2, 3, 5 for batch operation

Step 3: Update Status of selected rows to 'Completed'

Step 4: Final table after batch update

Cell Reference Map

    A        B
1 | Item   | Status   |
2 | Report1| Pending  | <-- selected
3 | Report2| Pending  | <-- selected
4 | Report3| Completed|
5 | Report4| Pending  | <-- selected

Rows 2, 3, and 5 are selected because their Status is 'Pending'. These cells feed into the batch update operation.

Result

    A        B
1 | Item   | Status   |
2 | Report1| Completed|
3 | Report2| Completed|
4 | Report3| Completed|
5 | Report4| Completed|

After batch operation, all selected reports have their Status changed to 'Completed'.

Sheet Trace Quiz - 3 Questions

Which rows are selected for the batch update?

A Rows 1, 4, and 5

B Rows 2, 3, and 5

C Rows 3 and 4 only

D All rows

Key Result

Select rows where condition is true, then apply batch update to selected rows