The problem this solves

You type a formula, the cell shows #REF! or #VALUE! or #N/A, and you're none the wiser. The old fix was to copy the error into a search engine and wade through forum threads. Most desk workers don't write formulas often enough to remember the rules, so a small error means a frustrating ten minutes for a one-character fix.

What's new

When you enter a formula that has an error, Gemini now shows a Fix button. Click it and the Gemini sidebar opens on the right, looks at your formula and the surrounding data, explains what went wrong in plain language, and corrects the formula inline where it can. The feature began rolling out on 22 June 2026 and can take up to 15 days to appear for everyone. Through 15 July, Google Workspace customers get promotional access to higher usage limits, so it's a good window to try it freely.

How to use it

There's almost nothing to learn. When a formula errors, look for the Fix button near the cell or in the Gemini panel and click it. Read the explanation, check the suggested formula makes sense for what you intended, and accept it if it does. That's the whole flow — no prompt to write, no menu to hunt through.

If you don't see a Fix button yet, the rollout may not have reached your account, or your organisation may manage which Gemini features are switched on. In that case you can still get help the manual way: open the Gemini side panel and describe the problem yourself.

Treat it as a lesson, not just a fix

The useful part isn't only that it fixes the formula — it's that it tells you why it broke. Read the explanation rather than clicking straight past it. Over a few weeks you'll start recognising the common culprits: a reference that points at a deleted column, text where a number should be, a range that doesn't line up. Learn the pattern once and you'll stop hitting the same error.

When you don't have the button

The same plain-English help works in any AI chat tool, even without the Sheets feature. Copy your formula and a description of the error, and ask. Here's a prompt that works anywhere:

This Google Sheets formula is giving me a [paste the exact error, e.g. #REF!] error. Explain in plain English what's causing it, then give me a corrected version. What I'm trying to do: [describe it, e.g. "add up column D only where column B says 'Marketing'"] My formula: [paste the formula] My columns: [briefly list what's in the relevant columns]
💡 This week's action

Open a Google Sheet you're working on and look for the Fix button the next time a formula errors — or test it deliberately by writing a formula you know is slightly wrong. When it explains the fix, read the explanation before accepting it. One genuine "ah, that's why" is worth more than ten silent corrections.