Spreadsheet Formula Debugger
Diagnose a broken formula from the sheet structure, expected behavior, and edge cases before proposing a fix.
Make it yours
Add your details and the prompt updates as you type. Or copy the reusable template to fill in later.
Why does each prompt ask different questions?
Each [PLACEHOLDER] in a prompt becomes a field. A meeting prompt may ask for notes; a learning prompt may ask for a topic. When you share your own prompt, you choose these placeholders. See an example →
Add the app for your task. A short description or pasted notes work well.
Add the formula for your task. A short description or pasted notes work well.
Add the sheet layout for your task. A short description or pasted notes work well.
Add the expected for your task. A short description or pasted notes work well.
Add the examples for your task. A short description or pasted notes work well.
Your prompt
The complete template, ready to reuse.
Free to copy. No account needed.
Try it in your AI tool
Choose a tool to copy this prompt and open a new tab. Paste it there to get started.
Your chosen service may require sign-in. Features and usage limits vary; choose a tool that supports the result you want.
Paste into your AI tool, run it, and review the result.
What to expect
A traced root cause, minimal corrected formula, edge cases, and five-row test table.
This describes the intended result. Review your output for accuracy and fit.
A little context goes a long way
- Fill in the details above, or replace any remaining [placeholders] after copying.
- Replace real customer data with representative examples.
- State Excel/Google Sheets and locale.
- Test the correction on a copy before filling an entire column.
Make the result work for you
Use this as a starting point in your AI tool. Results vary by tool and context. Check the output, add what’s missing, and ask for a revision.
New to prompts? Start here