June 22, 2026
Troubleshoot formula errors quickly with Gemini in Google Sheets
We’re excited to introduce a new Gemini in Sheets capability that enables you to diagnose and fix formula errors in one click. When you encounter a formula error, Gemini can analyze the surrounding data structure to help provide an easy-to-understand explanation of the core issue alongside a corrected version of the formula. The functionality seamlessly supports everything from basic arithmetic to highly intricate calculations, simplifying what is traditionally a frustrating and time-consuming debugging process.
Since Gemini is built directly in Sheets, it removes the barrier to writing complex formulas for advanced analysis right where you work. This ensures that both novice users and seasoned data analysts can maintain momentum without having to manually parse error messages or search external forums for solutions.
Getting started
- Admins: This feature is available by default if Gemini for Workspace in Sheets is enabled.
- End users: You must have Workspace smart features enabled to take advantage of these features. Visit the Help Center to learn more about building and editing spreadsheets with Gemini in Sheets.
Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for the improved Gemini in Sheets experience, allowing users to experiment with this feature.. Per-user usage limits will apply after July 15; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 22, 2026
Availability
- Business: Business Standard and Plus
- Enterprise: Enterprise Standard and Plus
- Consumer: Google AI Pro and Ultra
- Education Add-ons: Google AI Pro for Education
- Other Add-ons: AI Expanded Access*
*After July 15, 2026, users with AI Expanded Access licenses will have higher limits on usage of this feature.
Resources
- Google Docs Editors Help: Collaborate with Gemini in Google Sheets