Google Gemini adds AI formula fixer in Sheets, new user‑focused

Google’s Gemini AI now automatically detects formula errors in Google Sheets and suggests corrected formulas, a feature rolling out to Business, Enterprise, Education, AI Pro and AI Ultra users with expanded usage limits until July 15 2026 [2].

AI‑assisted error correction in Sheets

Google says Gemini can analyze a faulty formula, the surrounding cells, and then display a “Fix” button that opens a sidebar with a plain‑language explanation and the correct formula [2]. This goes beyond Sheets’ native generic error messages (e.g., “#REF!”) by providing a specific diagnosis and a ready‑to‑paste replacement. The capability applies to simple and complex equations alike, aiming to keep users focused on their work rather than troubleshooting syntax.

Broader Gemini updates and usage limits

The formula‑fixing upgrade arrives just weeks after Google added custom instructions for Gemini in Docs, expanding the AI’s productivity toolkit. Google also highlighted recent Gemini releases—Gemini 3.5 Flash and Gemini Omni Spark—and noted that the Gemini family now spans 13 products, each serving over a billion users [1]. To encourage adoption, the company is temporarily raising per‑usage caps for the Sheets AI feature until mid‑July 2026; after that date, only users with AI Expanded Access licenses will retain the higher limits [2].

What to watch

• July 15 2026 limit deadline – monitor whether Google announces new pricing or caps for post‑deadline users.
• Expansion to other apps – watch for similar AI‑driven assistance (e.g., error fixing) in Google Docs or Slides.
• Competitive response – keep an eye on Microsoft’s Copilot updates for Excel, which could spur a feature race in spreadsheet AI assistance.

These enhancements signal Google’s push to embed generative AI deeper into everyday productivity tools, turning Gemini from a conversational chatbot into a practical assistant that reduces manual error‑handling across its suite. The open question is how quickly users will adopt the new AI fixes and whether the temporary usage boost will translate into lasting demand for higher‑limit plans.