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
- Which spreadsheet app you use: Excel, Google Sheets, Numbers, or another. Formulas differ a little between them.
- How your sheet is set up: what's in each column, and which row your data starts on.
- What you want to work out, in plain words.
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
- 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.
- Copy the prompt and paste it into a new chat with your assistant.
- Try the formula on a copy of your sheet first, or in an empty column.
- Check the result against a few rows you can add up yourself.
- 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
- Describe the data, don't paste it. Leave out real names, account numbers, and anything private. A made-up example row works just as well.
- Ask what each part does. You'll be able to fix the formula yourself next time, and you'll notice if something looks wrong.
- Check with numbers you know. Assistants can get formulas slightly wrong, like using the wrong column or missing the last row. A quick test catches it.
- Ask for a simpler way. Sometimes a filter, a sort, or a pivot table is easier than a formula. Ask "Is there an easier way to do this?"
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.