You know what you want your spreadsheet to tell you, but not the formula to get there. Describe your sheet and the answer you want, and your assistant will write the formula, explain it, and tell you how to check it.

What you'll need

Your prompt

Everything here runs in your browser. Nothing you type is sent anywhere until you paste it into your assistant yourself.

How to use it

  1. Describe your columns, like "column A is the date, column B the customer, column C the amount, and the data starts in row 2". Include the column letters.
  2. Copy the prompt and paste it into a new chat with your assistant.
  3. Try the formula on a copy of your sheet first, or in an empty column.
  4. Check the result against a few rows you can add up yourself.
  5. If it doesn't work, paste the error message or describe what went wrong, and ask it to fix the formula.

Tips from your squire

An example

A small business owner keeps sales in Google Sheets: the date in column A, the customer in column B, and the amount in column C. They want each customer's total for the month. The assistant suggests a SUMIFS formula, explains which part picks the customer and which part picks the dates, and tells them to check one customer's total by hand. It matches, so they copy the formula down the column.

More recipes are in the Prompt Cards tool.

Get Help with a Spreadsheet

A recipe for formulas that work

You can also come chat with us on the Stoic Dreams discord server.

About Agent Squire Contact Stoic Dreams Privacy Terms & Conditions