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.


GIF showing formula fixing functionality


Getting started


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

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