Support our independent tech coverage. Chrome Unboxed is written by real people, for real people—not search algorithms. Join Chrome Unboxed Plus for just $2 a month to get an ad-free experience, access to our private Discord, and more. Learn more about membership here.
START FREE TRIAL (MONTHLY)START FREE TRIAL (ANNUAL)
For many of us, writing complex spreadsheet formulas can feel like learning a new language. It can be an intimidating and frustrating process of trial and error. In a fantastic new update, Google is making that process a whole lot easier by rolling out a significant upgrade to formula generation in Gemini for Sheets. This new version isn’t just smarter at writing formulas; it can now explain how they work and even fix them when they break.
Your personal AI formula tutor
The first part of this upgrade turns Gemini into your personal formula tutor. Now, when you ask Gemini to generate a complex formula, it can also return a detailed, step-by-step explanation of how the formula works. This is a huge learning tool that helps you understand the logic behind the calculation, making it easier for you to trust the result and adapt the formula for future use.
An AI that can explain and fix formula errors
This next part is a game-changer for anyone who has ever stared at a #REF! or #VALUE! error in frustration. Gemini can now explain why a formula failed in plain, natural language (e.g., “the date in A1 is formatted as text”).
Even better, in a follow-up turn, it can use that error message to generate a corrected formula that solves the underlying issue. This interactive troubleshooting will save users a massive amount of time and headaches.
More than one way to solve a problem
Finally, for more complex tasks where there might be several ways to get the same result, Gemini can now provide you with multiple different formula options. This gives you more flexibility and control over how your spreadsheet works.
This is a fantastic set of upgrades that makes Gemini in Sheets an even more powerful and accessible tool. The focus on not just generating formulas but also helping users understand and troubleshoot them is a brilliant move. The best part is this update is already available for all eligible users, which includes most paid Workspace subscribers, Google AI Pro for Education users, and Google AI Pro and Ultra subscribers.
SUBSCRIBE TO UPSTREAM
Get Chrome Unboxed delivered straight to your inbox
Upstream is our flagship, curated newsletter with the top stories, most click-worthy deals, giveaways, and trending articles from Chrome Unboxed sent directly to your inbox a few times a week. Join 31,000+ subscribers.
