Google Sheets prompts Page 4 of 6
Prompts
-
Team Vacation and Leave Planner
Coordinate time off and coverage.
-
Product Launch Countdown Planner
Plan tasks backward from a launch date.
-
Class or Training Schedule Planner
Coordinate sessions, rooms, and instructors.
-
Dependent Dropdown Troubleshooter: Why Is My List Broken?
Diagnose a broken dependent dropdown by answering guided questions, then get a ranked list of likely causes and a fix for each one.
-
Conditional Formatting Rule Audit and Cleanup Plan
Audit a sheet with messy conditional formatting rules, find duplicates, overlaps and slow rules, and get a cleanup plan without losing highlights.
-
Power Query Merge Two Tables Like a Lookup
Merge two tables in Power Query to replace slow lookups, with join types explained in plain words, a match check and refresh instructions.
-
Power Query Refresh Failures: Diagnose and Fix Checklist
Troubleshoot a Power Query refresh that fails or returns wrong data with a diagnosis table, step-by-step checks and prevention habits.
-
Cash Flow Forecast Template
Design a 12-month cash flow forecast template in a spreadsheet with formulas for inflows, outflows and running balance.
-
Profit and Loss Tracker by Month
Create an income statement tracker with variance.
-
Loan and Investment Calculator Sheet
Build calculators with amortization and scenarios.
-
Invoice and Accounts Receivable Tracker
Build an invoice and accounts receivable tracker in a spreadsheet with aging, follow-ups and a payment status view.
-
Break-Even and Pricing Scenario Model
Model price, volume, and cost trade-offs.
-
Sales Commission and Bonus Calculator
Compute payouts from tiers and quotas.
-
Rental Property or Investment Analysis Sheet
Evaluate returns with transparent assumptions.
-
Payroll and Labor Cost Planner
Forecast staffing cost and overtime.
-
Three-Scenario Financial Forecast Workbook
Build a base, downside, and upside forecast with a scenario switch.
-
Accounts Payable and Cash Planning Tracker
Plan bill payments around cash availability.
-
Variance Analysis Template: Budget vs Actual vs Forecast
Track three versions of the numbers.
-
Subscription Revenue Metrics Tracker (MRR and Churn)
Track recurring revenue health.
-
Expense Report and Reimbursement Tracker
Standardize employee expense reporting.
-
Tax Estimate and Quarterly Set-Aside Planner
Plan tax payments with a simple model (not tax advice).
-
Loan Amortization Schedule in Excel or Google Sheets
Create a loan amortization schedule in a spreadsheet, with PMT, interest and principal columns, extra payments and a zero-balance check.
-
Mortgage Payoff Spreadsheet With Extra Payment Scenarios
Model extra mortgage payments in a spreadsheet and compare payoff dates and total interest across scenarios, with a clear comparison table.
-
Amortization Schedule Check: Find Errors in My Loan Sheet
Review your amortization spreadsheet for formula mistakes, rounding drift and rate errors, with a findings table and corrected formulas.
-
Restaurant Food Cost Percentage Formulas
Calculate plate cost, theoretical and actual food cost.
-
Payroll Hours and Overtime Calculations From Time Clock Exports
Turn raw punches into paid hours with transparent rules.
-
Rental Property Cash Flow Formulas
Model rent, costs and returns line by line.
-
Exam Item Analysis Formulas for Teachers
Find which questions were too easy, too hard or confusing.
-
League Standings and Tiebreaker Formulas
Rank teams automatically with clear tiebreak rules.
-
Strength Training Log Formulas
Track volume, estimated maximums and weekly progress.
-
Project Burn-Down and Remaining Work Formulas
Show progress and forecast completion from task data.
-
Subscription Revenue, Churn and Retention Formulas
Compute recurring revenue metrics from a customer list.
-
Shift Coverage Check Formulas
Highlight understaffed hours before the week starts.
-
Loan Amortisation Schedule Built by Formulas
Understand how payments split between interest and principal.
-
Wedding or Party Budget Tracker Formulas
Track estimates, deposits and balances with variance.
-
ABC Inventory Classification Formulas
Group items by value to focus attention.
-
Likert Survey Summary Formulas
Summarise rating questions clearly and reversibly.
-
Vehicle Mileage and Running Cost Formulas
Track fuel efficiency and cost per distance.
-
Recipe Scaling and Unit Conversion Formulas
Resize recipes without arithmetic mistakes.
-
Appointment Slot Availability Formulas
Show open slots from a booking list for a small salon or clinic.
-
Event Ticket Sales Tracking and Pace Formulas
Compare ticket sales with a target pace.
-
Donor Retention and Giving Analysis Formulas
Measure repeat giving from a donation list.
-
Lease Expiry and Rent Roll Alert Formulas
Flag leases and rent changes that need action.
-
Cohort Retention Table Formulas
Build a month-by-month retention triangle.
-
Keyword List Cleaning and Grouping Formulas
Prepare SEO keyword data for planning.
-
Ecommerce Margin After Fees and Shipping
Calculate real profit per product and order.
-
Time Zone Meeting Planner Formulas
Find overlapping working hours across locations.
-
Bank Statement Categorisation Rules by Formula
Categorise transactions consistently with an editable rules table.