smeautomation
Log inSign up free

Home · Jobs & career · Write a simple spreadsheet formula that works

Just ask 1 minUnder a minute

Write a simple spreadsheet formula that works

You know what you want the cell to do and the formula bar wins. Get the formula and a plain explanation.

Updated 17 Oct 2026

The prompt · ChatGPT

Write a spreadsheet formula for me.

Sheets or Excel: [which]
What the sheet has: [columns]
What I want: [e.g. total, average, if overdue]
Example rows: [optional]

Ask me up to 3 short questions first if anything important is missing. Wait for my answers.

Then:
1. The formula.
2. Where to paste it.
3. Plain explanation.
4. Two test cases to check it.

Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts, steps or official URLs you're not sure of. UK English.

Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.

A short example

Fill the blanks, then paste. which: a short note you already have. columns: a short note you already have. Leave the rest of the prompt as written.

Loading the outline…