Google Sheets prompts Page 6 of 6
Prompts
-
Google Sheets Filter Views, Protected Ranges and Permissions Plan
Let several people use one sheet without breaking it.
-
Google Sheets Dashboard With Sparklines and Conditional Formatting
Build a compact one-page dashboard.
-
Google Sheets Import Functions Planner for Public Data
Plan IMPORTHTML, IMPORTXML or IMPORTDATA use responsibly.
-
Google Sheets Weekly Timesheet With Checkboxes and Totals
Build a simple timesheet with validation and totals.
-
Google Sheets GOOGLEFINANCE and Currency Table for Education Only
Learn how to pull price and exchange data into a sheet without giving advice.
-
Google Sheets Inventory Tracker With Low-Stock Alerts
Track stock with a script-free alert approach and optional script.
-
Google Sheets Named Functions and Template Library Plan
Create reusable formulas and templates for a team.
-
Google Sheets Survey Results Summary With Pivot Tables
Summarise survey answers by group.
-
Dependent Dropdown in Google Sheets Without Scripts
Create dependent dropdowns in Google Sheets with data validation and formulas, no script needed, including a layout tab and an error troubleshooter.
-
Google Sheets Conditional Formatting for Status Trackers
Make a Google Sheets tracker highlight statuses, deadlines and blanks with custom formula rules, explained for beginners with paste-ready formulas.
-
Google Sheets QUERY Function Builder for Your Data
Build a Google Sheets QUERY formula from plain English for your own columns, with select, where, group by, order by and label clauses explained.
-
QUERY Function Formula Fixer and Explainer
Paste a broken Google Sheets QUERY formula and get a plain English explanation, the likely error, a corrected formula and a short test plan.
-
QUERY Practice Sheet: Ten Exercises With Answers
Learn the Google Sheets QUERY function with ten graded exercises on your own kind of data, an answer key and a 1 to 5 self-score.
-
Small Business Inventory Tracker
Track stock levels with reorder alerts.
-
Inventory Turnover and ABC Analysis
Classify products and compute turnover.
-
Equipment and Asset Register
Track assets, maintenance, and depreciation.
-
Recipe Costing and Menu Pricing Sheet
Compute plate cost and menu prices.
-
Warehouse and Stock Location Map
Organize locations and pick lists.
-
Supplier Scorecard and Purchase Order Tracker
Compare suppliers and manage orders.
-
Event Equipment and Rental Inventory Sheet
Track availability across bookings.
-
Personal or Family Home Inventory for Insurance
Build a personal or family home inventory for insurance, listing items, values, receipts and photos in one spreadsheet.
-
Inventory Forecasting and Safety Stock Model
Forecast demand and set reorder levels.
-
Subscription Box or Recurring Order Tracker
Manage recurring customers, shipments, and stock.
-
Consumables and Supplies Usage Tracker
Know what you use and when to reorder.
-
Product Returns and Restocking Log
Track returns through inspection to resale or disposal.
-
Seasonal Inventory Planning Sheet
Plan stock for peaks and troughs.
-
Batch and Expiry Date Tracking Sheet
Manage perishable or batch-tracked stock.
-
Project Tracker With Status Dashboard
Build a project tracker in a spreadsheet with a status dashboard, using formulas to summarise progress and overdue tasks.
-
Sprint Backlog and Velocity Tracker
Track agile work with velocity calculations.
-
Risk Register and Issue Log
Create a scored risk register.
-
Client Pipeline and CRM Sheet
Build a lightweight sales pipeline tracker.
-
Gantt Chart in a Spreadsheet
Visualize timelines with formulas.
-
Client Project Time Tracking and Billing
Track hours and generate invoices.
-
OKR and Goal Progress Tracker
Track objectives and key results across a team.
-
Content Production Pipeline Tracker
Track pieces from idea to publication.
-
Issue and Defect Tracker With Metrics
Track issues from report to resolution with trend charts.
-
Budget, Schedule and Scope Health Dashboard for a Project
Build a project health dashboard in a spreadsheet that combines budget, schedule and scope into one status view.
-
Stakeholder Register and Communication Plan
Track who needs what information when.
-
Change Request Log and Impact Tracker
Control scope changes systematically.
-
Meeting Action Item Tracker
Follow through on actions from meetings.
-
Resource Cost Tracker for Projects
Track labor and expense costs per project.
-
Google Sheets Booking and Resource Schedule With Conflict Check
Prevent double bookings in a shared sheet.
-
Google Sheets Dependent Dropdowns for an Order or Request Form
Build linked choices that stay valid.
-
Google Sheets Weekly CSV Import and Cleaning Routine
Create a repeatable path from an export to a clean tab.
-
Google Sheets Volunteer Hours and Impact Tracker
Track hours, roles and totals for a community group.