Google is giving Gemini in Sheets a genuinely practical new trick. It can now help users figure out why a formula isn’t working and suggest a fix automatically.
The feature is rolling out now and tackles one of the most common frustrations in spreadsheets. While Gemini could already generate formulas for users, it wasn’t much help when something broke after a formula was entered manually. That’s now changing. Gemini is now able to analyse both the formula and the surrounding cells to explain what went wrong and how to fix it.
When Sheets detects a formula error, users will now see a new Fix button. Clicking it opens the Gemini sidebar. In this sidebar, the AI explains the issue in plain language and suggests a corrected version of the formula.
That might sound like a small change, but anyone who spends a lot of time in spreadsheets will know how cryptic errors like #REF!, #VALUE!, and #N/A can be. Sheets already flags these issues. However, the explanations are often either too technical or too vague to be particularly useful.
Google says Gemini can bridge that gap by translating spreadsheet jargon into something easier to understand. Rather than sending users to a support page or forcing them to search for answers online, the AI can identify the problem directly within the spreadsheet. It can also recommend a solution.
The company also says the tool can help with everything from simple calculations to more advanced formulas. This potentially makes it easier for users to build complex spreadsheets without worrying about breaking them.
Importantly, this feels like the kind of AI feature that solves a real problem rather than creating a new workflow. Many recent Gemini additions have focused on generating content or automating tasks. However, spreadsheet troubleshooting is something users regularly run into, especially in business and education environments.
The upgraded Gemini experience is rolling out now to Business, Enterprise, Education, AI Pro, and AI Ultrasubscribers.
Google is also temporarily increasing usage limits until 15 July 2026, giving users more opportunities to try the new functionality. After that date, standard usage limits will return, with expanded allowances reserved for users on AI Expanded Access licences.
The update arrives just over a month after Google added custom instructions to Gemini in Docs. This suggests the company is continuing to push its AI tools deeper into Workspace.
The post This Google Sheets Gemini upgrade is perfect for those who hate spreadsheets appeared first on Trusted Reviews.