Subj : Gemini in Google Sheets can now explain and fix broken formulas To : All From : TechnologyDaily Date : Fri Sep 26 2025 12:30:09 Gemini in Google Sheets can now explain and fix broken formulas Date: Fri, 26 Sep 2025 11:24:26 +0000 Description: Gemini for Google Sheets can now explain, fix, and teach spreadsheet formulas. FULL STORY ======================================================================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 youve 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 dont. 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 youre trying to calculate the number of people who RSVPd yes in a list filtered by zip code, and your formula crashes. Gemini might explain that the column its referencing is formatted as text instead of dates, or that a range doesnt match your filters. Then it could offer a corrected formula that works. And if theres more than one way to calculate your answer, it can show you multiple formula options. This kind of support isnt just for novices, either. Even seasoned spreadsheet users occasionally mistype a cell range or forget that a column is full of inconsistent data types. Geminis new ability to self-diagnose errors and explain them offers a safety net that lets you move faster without fear of hidden bugsor 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 its 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 Microsofts 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. Geminis ability to explain its formulas as it generates them gives users a chance to understand what theyre actually doing, instead of just trusting the black box of AI. Of course, its 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 ====================================================================== Link to news story: https://www.techradar.com/ai-platforms-assistants/gemini/gemini-in-google-shee ts-can-now-explain-and-fix-broken-formulas --- Mystic BBS v1.12 A49 (Linux/64) * Origin: tqwNet Technology News (1337:1/100) .