Google Gemini adds formula‑fix feature in Sheets, rolls out new AI

Google’s Gemini AI now automatically detects and corrects formula errors in Google Sheets, displaying a “Fix” button that opens a sidebar with an explanation and the corrected formula [2]. The upgrade, which is live for Business, Enterprise, Education, AI Pro and AI Ultra customers, also raises usage limits through July 15 2026 before stricter caps apply [2].

Auto‑fix in Sheets

Google says the new Gemini integration scans the entered formula and surrounding cells, then surfaces a concise error description and the exact replacement formula [2]. This goes beyond Sheets’ native generic error messages (e.g., “#REF!”) by providing actionable guidance, a claim that addresses long‑standing user frustration with cryptic alerts. The “Fix” button appears automatically when an error is detected, streamlining the debugging workflow for both simple and complex equations.

Limits and rollout scope

The enhanced Gemini experience is initially limited to users with Business, Enterprise, Education, AI Pro and AI Ultra licenses. Google will keep higher per‑usage limits in place until mid‑July 2026, after which only customers with AI Expanded Access licenses will retain elevated caps [2]. This temporary lift mirrors Google’s broader strategy of expanding Gemini’s reach—recent updates include Gemini 3.5 Flash and Gemini Omni Spark, bringing the suite to 13 products each serving over a billion users [1].

What to watch

• July 15 2026 – End of the current higher‑limit period; watch for any announced changes to usage caps.
• Future Gemini updates – Monitor Google’s roadmap for additional on‑device or offline features that could complement the Sheets auto‑fix.
• Competitor responses – Keep an eye on Microsoft’s Copilot enhancements in Excel, which may accelerate parity battles in AI‑assisted spreadsheet tooling.

Google’s formula‑fix rollout underscores its push to embed generative AI deeper into everyday productivity apps, while the extended usage window gives enterprises a runway to adopt the feature before tighter limits take effect. Whether the auto‑fix will become a decisive advantage over rivals remains to be seen.