Read the why, not just the fix: using AI's formula repair as a free lesson

Overview

Why now. As of late June 2026, Google Sheets started catching your broken formulas for you. Enter a formula that errors, hover over the flagged cell, and a Fix button appears; click it and Gemini opens a side panel that explains in plain English what went wrong and hands you a corrected version — rolling out from 22 June 2026. Excel’s Copilot does the neighbouring job, explaining what a formula does and suggesting a working one. The thing worth learning isn’t the button. It’s what you do in the two seconds after you click it.

The content

The obvious move is the fast one: click Fix, the error disappears, you get on with your day. The panel handed you a working formula and you took it. Done.

Look again at what it actually gave you. Two different things arrived in that panel — a corrected formula, and an explanation of why the old one failed — and the reflex to grab the first and skip the second is exactly backwards. The formula is the patch; the explanation is the lesson, and the lesson is the only part that travels. It tells you the class of mistake you made — a reference that shifted when you copied it down, a range that stopped one row short, text sitting where a number should be — which is what stops you making it again next week. Take the repair, skip the reason, and you’ve swapped a visible error for a working-looking cell you couldn’t rebuild if it broke.

There’s a second reason to read before you trust it. A formula that stops erroring is not the same as a formula that’s right. The fixer’s job is to make the error symptom go away, and it can do that by quietly changing what you meant — widening a range, swapping an operator, coercing a type — and still return a confident, wrong number. #REF! at least announces itself. A plausible total that’s off by one column says nothing. So read the explanation, then check the new formula against one row you can work out by hand, before you rely on it.

This is a habit, not a Google feature. The same discipline fits every AI-repairs-it-for-you surface: Excel’s Copilot explaining a formula, a writing assistant that rewrites a clunky sentence and tells you what was wrong with it. The tool that shows you what it changed and why is inviting you to check it. The skill is accepting the invitation.

Try it

Open a real sheet with a formula that’s erroring — or one whose result you’re quietly unsure of. Then, before you rely on the result:

1. Trigger the repair (in Sheets, the Fix button on the error; in Excel, ask Copilot to explain the formula).
2. Read the explanation first — before you look at the new formula. Say the error class out loud: “unanchored reference”, “range too short”, “wrong type”. That sentence is the thing you’re keeping.
3. Now look at the rewrite, and test it against one row or cell you can verify yourself. Only then rely on it.

Where it breaks: the fixer only fires on formulas that error. A formula that runs cleanly but computes the wrong thing — right syntax, wrong logic; summing the column beside the one you meant — never trips the Fix button, and if you ask it to explain such a formula it will fluently rationalise it as written. It catches broken formulas, not wrong ones. Telling those apart is still your job.

Additional reading

• Troubleshoot formula errors quickly with Gemini in Google Sheets — Google Workspace Updates (June 2026) — the primary: a Fix button that explains the error and supplies a corrected formula, rolling out from 22 June 2026.
• Understand formulas with Copilot in Excel — Microsoft Support — the cross-tool parallel: Copilot explains what a formula does, so the explanation habit isn’t tied to one vendor. (Living page — as of July 2026.)
• Gemini in Google Sheets can now help you debug and fix formula errors — Neowin (June 2026) — a plain-language walkthrough of the feature in use.

Editor’s note

At the date of publication, I have used this feature exactly once. In a spreadsheet, that is. This is a module that I felt was worth publishing because of the transferable concept. When I’m working on a contract, and I use AI to get a second opinion about drafting that doesn’t feel right, the suggested amended language is almost never something that I would use verbatim (even if it’s correct, I have my drafting preferences). However, the line explaining what it thinks is actually wrong with the original is almost always something that I find useful. The repair can solve the immediate issue, but the explanation is what helps me to grow as a professional.