By Eric Hal Schwartz
Copyright techradar
Skip to main content
Tech Radar Pro
Tech Radar Gaming
Close main menu
the business technology experts
België (Nederlands)
Deutschland
North America
US (English)
Australasia
New Zealand
View Profile
Search TechRadar
Best web hosting
Best office chairs
Best website builder
Best antivirus
Expert Insights
Don’t miss these
Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not
How to share your Gemini Gems custom AI experts with all your friends
Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave
Google just announced 5 new Gemini features coming to Android, and it’s good news for fans of foldable smartphones
Gemini just got a new highly-requested feature that trumps ChatGPT
Gemini is coming to Chrome on desktop starting today for Pro and Ultra users in the U.S.
Google Drive might finally be able to understand your PDFs a little better
Google Gemini’s new Guided Learning mode makes you smarter – one question at a time
I used Google Gemini to analyze YouTube, and the results were seriously impressive – 4 ways you can use video integration to get the most from AI
Google AI Mode is getting a bigger AI brain from Gemini
Gemini is about to remember everything, unless you tell it not to
Google rolls out Gemini for schools and students amidst concerns for the future of education across the globe
Gemini has a few tricks up its sleeve that ChatGPT still doesn’t – here are 3 things Gemini can do better than ChatGPT
Google Gemini is set to become a significantly better phone assistant thanks to these two small upgrades
Google Gemini and GitHub are teaming up for AI-powered coding
AI Platforms & Assistants
Gemini in Google Sheets can now explain and fix broken formulas
Eric Hal Schwartz
26 September 2025
Smarter Sheets and equations that always balance
When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.
(Image credit: Google)
Gemini in Google Sheets can now explain complex formulas in plain English
The assistant offers step-by-step breakdowns of the formulas to help teach users how they work
The AI assistant can also diagnose and fix broken formulas automatically
If you’ve ever stared blankly at a Google Sheets formula that spits out #REF! or #VALUE!, well, now you can ask Gemini for help. Google has upgraded its AI assistant for Sheets to fix and explain all those formulas, even the broken ones.
Gemini can now not only generate spreadsheet formulas but explain why they work, or arguably more importantly, why they sometimes don’t. The AI will explain it in simple language when there’s an error and how to fix it. It can even correct any errant elements of an equation automatically or provide multiple options if you ask it to set up a formula for a task. No more copying error codes into search bars or scrolling through forum threads.
(Image credit: Google)
Say you’re trying to calculate the number of people who RSVP’d “yes” in a list filtered by zip code, and your formula crashes. Gemini might explain that the column it’s referencing is formatted as text instead of dates, or that a range doesn’t match your filters. Then it could offer a corrected formula that works. And if there’s more than one way to calculate your answer, it can show you multiple formula options.
You may like
Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not
How to share your Gemini Gems custom AI experts with all your friends
Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave
This kind of support isn’t just for novices, either. Even seasoned spreadsheet users occasionally mistype a cell range or forget that a column is full of inconsistent data types. Gemini’s new ability to self-diagnose errors and explain them offers a safety net that lets you move faster without fear of hidden bugs—or worse, quiet miscalculations that go unnoticed. The explanations are detailed enough to teach, not just patch.
Smart Sheets
(Image credit: Google)
Google had already begun embedding its AI tools in Sheets, but that was limited to automation and chart creation. Now, Gemini has more of a fixer and educator role. Google says it’s part of an ongoing effort to make complex workflows more approachable and to put AI where people already work.
It also raises the stakes in the productivity AI arms race. Mainly, that means pitting Sheets and Gemini against Microsoft’s Copilot in Excel, but there are smaller rivals around as well. But, Gemini’s offering of real-time formula correction and multi-method explanations sets Google up with a specific niche, turning Sheets into a kind of dynamic learning environment rather than just a blank canvas for numbers.
That focus on education is what could make this stick. Gemini’s ability to explain its formulas as it generates them gives users a chance to understand what they’re actually doing, instead of just trusting the black box of AI.
Are you a pro? Subscribe to our newsletter
Sign up to the TechRadar Pro newsletter to get all the top news, opinion, features and guidance your business needs to succeed!
Contact me with news and offers from other Future brandsReceive email from us on behalf of our trusted partners or sponsorsBy submitting your information you agree to the Terms & Conditions and Privacy Policy and are aged 16 or over.
Of course, it’s not truly magic, and Gemini can still struggle with poorly labeled sheets or confusing requests. But being able to use words instead of math or code to describe what you want the Sheet to do is potentially an enormous time saver. You can just say, “I want to count orders over $50 that happened last month,” and let Gemini figure out the filter logic and the time-based math.
The update is already live for Google Workspace users with Gemini on the Business Standard and Plus, Enterprise tiers, as well as for those who subscribe to Google’s AI Pro or Ultra plans. You can check by seeing if you’ve got the “Ask Gemini” spark icon in the upper right corner of your Sheet.
You might also like
Gemini Gems are now free – here are 4 ways you can use custom AI experts to help cope with the stresses of your busy life
How to build your own customized Google Gemini AI chatbot
I can get answers from ChatGPT, but Deep Research gives me a whole dissertation I’ll almost never need
Google Sheets
Eric Hal Schwartz
Social Links Navigation
Contributor
Eric Hal Schwartz is a freelance writer for TechRadar with more than 15 years of experience covering the intersection of the world and technology. For the last five years, he served as head writer for Voicebot.ai and was on the leading edge of reporting on generative AI and large language models. He’s since become an expert on the products of generative AI models, such as OpenAI’s ChatGPT, Anthropic’s Claude, Google Gemini, and every other synthetic media tool. His experience runs the gamut of media, including print, digital, broadcast, and live events. Now, he’s continuing to tell the stories people want and need to hear about the rapidly evolving AI space and its impact on their lives. Eric is based in New York City.
You must confirm your public display name before commenting
Please logout and then login again, you will then be prompted to enter your display name.
Gemini is coming to solve all your Google Meet meeting issues – whether you want it or not
How to share your Gemini Gems custom AI experts with all your friends
Gemini Live can now coordinate your outfit and remind you – in a calm voice – when it’s time to leave
Google just announced 5 new Gemini features coming to Android, and it’s good news for fans of foldable smartphones
Gemini just got a new highly-requested feature that trumps ChatGPT
Gemini is coming to Chrome on desktop starting today for Pro and Ultra users in the U.S.
Latest in Gemini
Google Mixboard is your new AI-powered creative playground
Google’s AI Search Live makes search a conversation and Googling might never be the same
The Pixel 10’s best AI feature is now available on other Android smartphones – here’s how to try the new Google Photos update
Gemini is coming to Google TV – now your big screen can actually talk back
How to share your Gemini Gems custom AI experts with all your friends
Gemini is coming to Chrome on desktop starting today for Pro and Ultra users in the U.S.
Latest in News
How to watch Power Book IV: Force season 3 online — when is it coming out?
Hands-on video leak reveals Samsung Galaxy One UI 8.5 – and it’s borrowing a handy iPhone trick
Peacemaker season 2 episode 6’s big cameo is the perfect set up for Man of Tomorrow
Bowser (no, not that one) will retire from Nintendo at the end of the year
The Xiaomi 17 Pro Max has landed with two screens and a ridiculously big battery
Dell is launching its own earbuds specifically designed for video calls – but will they even come close to Apple AirPods?
LATEST ARTICLES
The four-star Ring Video Doorbell Pro tumbles to a record-low price
Dell is launching its own earbuds specifically designed for video calls – but will they even come close to Apple AirPods?
A team of iPhone 17 Pro phones will step up to the plate on Apple TV+’s Friday Night Baseball
Peacemaker season 2 episode 6 gives us the show’s most crowd-pleasing cameo yet – and it’s the perfect set up for Man of Tomorrow
Hands-on video leak reveals Samsung Galaxy One UI 8.5 – and it’s borrowing a handy iPhone trick
TechRadar is part of Future US Inc, an international media group and leading digital publisher. Visit our corporate site.
Contact Future’s experts
Terms and conditions
Privacy policy
Cookies policy
Advertise with us
Web notifications
Accessibility Statement
Future US, Inc. Full 7th Floor, 130 West 42nd Street,
Please login or signup to comment
Please wait…
