Gemini in Google Sheets now provides smarter, more conversational formula generation

September 24, 2025

Gemini in Google Sheets now provides smarter, more conversational formula generation

What’s changing
Earlier this year, we made it easier to generate charts and insights using Gemini in Google Sheets. Building on that momentum, we’re excited to announce a significant enhancement to formula generation in Gemini for Sheets. Specifically, we've upgraded Gemini to include detailed natural language formula explanations, provide formula error explanation and self-correction, and to output multiple formula options.

With these updates, Gemini can provide a full, reasoned response, making formula generation smarter and more resilient, and helping users to understand the formulas and calculations happening in their sheets.

1. Detailed natural language formula explanations:
   Complex formulas can now be returned with step-by-step explanations of how they work. This improves user understanding and builds trust, making it easier to learn and adapt formulas for future use. If Gemini doesn’t provide an explanation as part of the response, you can always ask in your next query how the generated formula works.

2. Error explanation and self-correction:
Gemini can now explain why a formula failed (e.g., "the date in A1 is formatted as text") and, in a follow-up turn, use the error message to generate a corrected formula that solves the underlying issue.

3. Multiple formula options:
For more complex tasks or when there are several ways to achieve a result, Gemini can now provide multiple formulas.

Getting started

• Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the personalization setting for their users in the Admin console.
• End users: You can access Gemini for Sheets in the side panel by clicking on “Ask Gemini” (spark button) in the top right corner of Sheets. Visit the Help Center to learn more about collaborating with Gemini in Sheets.

Rollout pace

• This update is already available for all Gemini users.

Availability
Available for Google Workspace:

• Business Standard and Plus
• Enterprise Standard and Plus
• Google AI Pro for Education

Also available to:

• Google AI Pro and Ultra

Anyone who previously purchased these add-ons will also receive this feature:

• Gemini Business* Gemini Enterprise