All prompts

4392 prompts, 48 per page. Want to filter? Use search.

Prompts

• Date Calculation Formulas That Handle Real Cases

  Compute ages, deadlines, and durations correctly.

  Create Spreadsheets / Formulas & Functions

• Conditional Formatting Rule Writer

  Highlight what matters with custom rules.

  Create Spreadsheets / Formulas & Functions

• Data Validation and Dependent Dropdowns

  Control inputs and chain dropdown lists.

  Create Spreadsheets / Formulas & Functions

• IFERROR and Error-Proofing Formulas

  Handle errors without hiding real problems.

  Create Spreadsheets / Formulas & Functions

• Nested IF to IFS and SWITCH Simplifier

  Rewrite tangled logic into readable formulas.

  Create Spreadsheets / Formulas & Functions

• Running Totals and Moving Averages

  Track cumulative values and trends.

  Create Spreadsheets / Formulas & Functions

• Ranking and Percentile Formulas

  Rank items fairly and handle ties.

  Create Spreadsheets / Formulas & Functions

• Return All Matches Lookup Formulas

  Pull every row that matches, not just the first.

  Create Spreadsheets / Formulas & Functions

• Partial Text and Approximate Matching

  Match names that are not exactly the same.

  Create Spreadsheets / Formulas & Functions

• Formula Debugging Interview

  Find why a formula returns the wrong answer.

  Create Spreadsheets / Formulas & Functions

• Formula Explainer: Break It Down Step by Step

  Understand a complicated formula you inherited.

  Create Spreadsheets / Formulas & Functions

• LET and LAMBDA for Readable Formulas

  Name intermediate values and build reusable functions.

  Create Spreadsheets / Formulas & Functions

• Cross-Sheet Consolidation Formulas

  Combine data from several sheets or files.

  Create Spreadsheets / Formulas & Functions

• Financial Functions Walkthrough: PMT, NPV, IRR

  Use finance formulas correctly with examples.

  Create Spreadsheets / Formulas & Functions

• Statistical Functions for Beginners

  Describe data with the right measures.

  Create Spreadsheets / Formulas & Functions

• Inventory and Reorder Formulas

  Calculate stock, reorder points, and order quantities.

  Create Spreadsheets / Formulas & Functions

• Attendance and Schedule Formulas

  Track hours, shifts, and absences.

  Create Spreadsheets / Formulas & Functions

• Gradebook Formulas for Teachers

  Calculate weighted grades and flag students.

  Create Spreadsheets / Formulas & Functions

• Commission and Tiered Pricing Formulas

  Calculate bonuses and bracketed rates correctly.

  Create Spreadsheets / Formulas & Functions

• Currency and Unit Conversion Formulas

  Convert reliably and keep rates auditable.

  Create Spreadsheets / Formulas & Functions

• Regular Expression Formulas in Google Sheets

  Extract and validate text patterns.

  Create Spreadsheets / Formulas & Functions

• IMPORTRANGE and Data Import Setup

  Pull data from other files safely.

  Create Spreadsheets / Formulas & Functions

• KPI Dashboard Formulas

  Compute the numbers that drive a dashboard.

  Create Spreadsheets / Formulas & Functions

• Duplicate Detection and Removal Formulas

  Find, flag, and handle repeated records.

  Create Spreadsheets / Formulas & Functions

• Excel to Google Sheets Formula Translation Table

  Move formulas between apps without surprises.

  Create Spreadsheets / Formulas & Functions

• Array Formula Performance Review

  Speed up slow workbooks.

  Create Spreadsheets / Formulas & Functions

• Named Ranges and Structured References Setup

  Make formulas readable and resilient.

  Create Spreadsheets / Formulas & Functions

• Checks and Reconciliation Formulas

  Build self-checking sheets.

  Create Spreadsheets / Formulas & Functions

• Formula Test Case Builder

  Create test data that proves a formula works.

  Create Spreadsheets / Formulas & Functions

• Business Day and Holiday Calendar Formulas

  Handle deadlines around weekends and holidays.

  Create Spreadsheets / Formulas & Functions

• Spill and Dynamic Range Troubleshooting

  Fix #SPILL! errors and unstable ranges.

  Create Spreadsheets / Formulas & Functions

• Pivot Table Alternatives Using Formulas

  Build live summaries without a pivot table.

  Create Spreadsheets / Formulas & Functions

• Small Business Inventory Tracker

  Track stock levels with reorder alerts.

  Create Spreadsheets / Inventory

• Inventory Turnover and ABC Analysis

  Classify products and compute turnover.

  Create Spreadsheets / Inventory

• Equipment and Asset Register

  Track assets, maintenance, and depreciation.

  Create Spreadsheets / Inventory

• Recipe Costing and Menu Pricing Sheet

  Compute plate cost and menu prices.

  Create Spreadsheets / Inventory

• Warehouse and Stock Location Map

  Organize locations and pick lists.

  Create Spreadsheets / Inventory

• Supplier Scorecard and Purchase Order Tracker

  Compare suppliers and manage orders.

  Create Spreadsheets / Inventory

• Event Equipment and Rental Inventory Sheet

  Track availability across bookings.

  Create Spreadsheets / Inventory

• Personal or Family Home Inventory for Insurance

  Document belongings and values.

  Create Spreadsheets / Inventory

• Inventory Forecasting and Safety Stock Model

  Forecast demand and set reorder levels.

  Create Spreadsheets / Inventory

• Subscription Box or Recurring Order Tracker

  Manage recurring customers, shipments, and stock.

  Create Spreadsheets / Inventory

• Consumables and Supplies Usage Tracker

  Know what you use and when to reorder.

  Create Spreadsheets / Inventory

• Product Returns and Restocking Log

  Track returns through inspection to resale or disposal.

  Create Spreadsheets / Inventory

• Seasonal Inventory Planning Sheet

  Plan stock for peaks and troughs.

  Create Spreadsheets / Inventory

• Batch and Expiry Date Tracking Sheet

  Manage perishable or batch-tracked stock.

  Create Spreadsheets / Inventory

• Project Tracker With Status Dashboard

  Build a task tracker with dashboard formulas.

  Create Spreadsheets / Project Tracking

• Sprint Backlog and Velocity Tracker

  Track agile work with velocity calculations.

  Create Spreadsheets / Project Tracking