Template gallery usage in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

This data shows a small list of templates available in a template gallery with their categories and descriptions.

Cell	Value
A1	Template Name
B1	Category
C1	Description
A2	Monthly Budget
B2	Finance
C2	Track your monthly income and expenses
A3	Project Timeline
B3	Project Management
C3	Plan and track project milestones
A4	Event Planner
B4	Events
C4	Organize event details and schedules
A5	Invoice
B5	Business
C5	Create professional invoices quickly

Formula Trace

=FILTER(A2:A5, B2:B5="Finance")

Step 1: B2:B5="Finance"

Step 2: FILTER(A2:A5, [TRUE, FALSE, FALSE, FALSE])

Cell Reference Map

    A           B               C
1 |Template Name|Category       |Description
2 |Monthly Budget|Finance       |Track your monthly income and expenses
3 |Project Timeline|Project Management|Plan and track project milestones
4 |Event Planner |Events        |Organize event details and schedules
5 |Invoice      |Business      |Create professional invoices quickly

Formula references B2:B5 and A2:A5

The formula uses the template names in A2:A5 and checks categories in B2:B5 to filter only those with 'Finance'.

Result

    A
1 |Filtered Templates
2 |Monthly Budget

The formula result shows only the template name 'Monthly Budget' because it is the only one in the 'Finance' category.

Sheet Trace Quiz - 3 Questions

What does the formula =FILTER(A2:A5, B2:B5="Finance") return?

A ["Project Timeline"]

B ["Event Planner"]

C ["Monthly Budget"]

D ["Invoice"]

Key Result

FILTER(range_to_return, condition_range=condition) filters values based on matching condition.