- Gemini in Google Sheets can now explain complex formulas in simple English
- The assistant offers outbursts of the formulas to help teach users how they work
- The AI assistant can also automatically diagnose and repair broken formulas
If you have already watched a Google Sheets formula that spits #ref! Or #Value!, well, now you can ask for geminum help. Google upgraded its AI assistant for the sheets to repair and explain all these formulas, even the broken.
Gemini can now not only generate calculation sheet formulas, but explain why they work, or probably more importantly why they do not. The AI will explain it in a simple language when there is an error and how to fix it. It can even automatically correct all the wandering elements of an equation or provide several options if you ask it to configure a formula for a task. More copying error codes in search or scrolling bars in forum threads.
Suppose you are trying to calculate the number of people who RSVP’D “yes” in a list filtered by postal code, and your formula is blocking. Gemini could explain that the column he refers is formatted in text instead of the dates, or that a beach does not correspond to your filters. Then it could offer an corrected formula that works. And if there is more than one way to calculate your answer, it can show you several formula options.
This type of support is not only for novices either. Even seasoned calculation sheet users sometimes typical a range of cells or forget that a column is full of inconsistent types of data. Gemini’s new capacity to self -diagnose errors and explain them offers a safety net that allows you to move faster without fear of hidden bugs – or worse silent calculation errors that go unnoticed. The explanations are sufficiently detailed to teach, not just the patch.
Smart sheets
Google had already started to integrate its AI tools into the leaves, but that was limited to automation and the creation of graphics. Now Gemini has more fixer and educator. Google says that it is part of a continuous effort to make the workflows complex more accessible and to put the AI where people are already working.
It also increases the challenges of AI armaments productivity. Mainly, this means opposing the leaves and Gemini to the co -pilot of Microsoft in Excel, but there are also smaller rivals around. But, the offer of gemini of formula correction in real time and multi-method explanations defines Google with a specific niche, transforming the leaves into a kind of dynamic learning environment rather than simply a virgin canvas for numbers.
This concentration on education is what could make this stick. Gemini’s ability to explain her formulas because she generates them gives users a chance to understand what they really do, instead of simply trusting the AI black box.
Of course, it’s not really magical, and Gemini can always fight with poorly labeled leaves or confusing requests. But being able to use words instead of mathematics or code to describe what you want the leaf doing is potentially a huge time saving. You can simply say: “I want to count the orders of more than $ 50 that occurred last month” and let Gemini determine the filter logic and the mathematics based on time.
The update is already live for users of Google Workspace with Gemini on the commercial standard and more, business levels, as well as for those who subscribe to the AI Pro or Ultra of Google. You can check when you have the Spark “Ask Gemini” icon in the upper right corner of your sheet.
