Template gallery usage in Google Sheets - Dashboard Guide

Dashboard Mode - Template gallery usage

Dashboard Goal

Help users quickly create useful spreadsheets by showing how to use Google Sheets template gallery for common tasks like budgeting, project tracking, and calendars.

Sample Data

Template Name	Category	Description	Use Case
Monthly Budget	Personal Finance	Track income and expenses monthly	Manage household budget
Project Tracker	Work	Monitor project tasks and deadlines	Team project management
Event Planner	Personal	Plan events with guest lists and schedules	Organize parties or meetings
Annual Calendar	Planning	Yearly calendar with holidays and notes	Plan yearly activities
Invoice	Business	Create professional invoices	Billing clients

Dashboard Components

• KPI Card: Total Templates Available
  Formula: =COUNTA(A2:A6)
  Shows how many templates are listed.
• Category Count Table: Count of templates by category
  Formula: =QUERY(A2:D6,"select B, count(A) group by B label count(A) 'Count'",0)
  Shows how many templates per category.
• Search Box: Cell where user types keyword to filter templates by name or description.
  Uses FILTER formula:
  =FILTER(A2:D6, REGEXMATCH(LOWER(A2:A6)&LOWER(C2:C6), LOWER(E2)))
  Filters templates matching search text in E2.
• Instructions Text: Explains how to open template gallery:
  "Go to File > New > From template gallery to pick a template."

Dashboard Layout

+----------------------+-----------------------+
| Total Templates: 5   | Search Templates: [E2]|
+----------------------+-----------------------+
| Category       | Count|                       
|----------------|------|                       
| Personal Finance| 1    |                       
| Work           | 1    |                       
| Personal       | 1    |                       
| Planning       | 1    |                       
| Business       | 1    |                       
+----------------+------+-----------------------+
| Instructions: Go to File > New > From template gallery |
+-------------------------------------------------------+

Interactivity

User types keywords in the search box (cell E2). The template list below updates to show only templates whose name or description contains the keyword. This helps users quickly find templates they need.

Self Check

If you type "project" in the search box, which templates appear in the filtered list? Answer: Only the "Project Tracker" template because its name or description contains "project".

Key Result

Dashboard shows how to use Google Sheets template gallery with template counts, categories, and search filter.