Google Sheets gets Gemini upgrade that fixes formula errors with one click

Gemini can now help you fix those broken Google Sheets formulas

This functionality will be available for Google AI Pro and Ultra users. How many times have you entered a formula into a spreadsheet only to see an error message? Sometimes you can spot the error right away, other times you may have no idea what went wrong. Google is rolling out a new capability in Sheets that should solve this problem. In a blog post, Google announced that Gemini in Sheets will now be able to diagnose and fix formula errors. The next time you see an error, one click will get Gemini to generate an explanation of the core problem. It will also provide you with a corrected version of the formula. According to the tech giant, the tool understands everything from basic arithmetic to more complex equations. So, if you're typing out a highly intricate calculation, it should still be able to help. The rollout of this new Gemini in Sheets feature starts today for Google AI Pro and Ultra users. It will also be available for Business Standard and Plus, Enterprise Standard and Plus, and Google AI Pro for Education. Google says Workspace customers will get higher usage limits through July 15 as a promotion. After July 15, AI Expanded Access users will get higher limits on usage.

Google Sheets gets a Gemini upgrade you'll actually use

For all the improvements that Google has rolled out to Gemini in Google Sheets, there's still a lot more it can do. While Gemini can help create new formulas in spreadsheets, it was of little help if you ran into an error when manually entering a formula. That's changing now, with Gemini in Google Sheets now capable of helping you troubleshoot formula errors. Google says that Gemini in Google Sheets can analyze the formula entered and the surrounding cells to provide you with a simple explanation about the error. More importantly, it will also provide the right formula that you can use. Gemini will automatically show a Fix button when you enter a formula that has an error. From there, the Gemini sidebar will open on the right, explaining the error and providing the right formula. While Sheets already flags formula errors, it provides a generic error message with a limited explanation of what's exactly wrong. Plus, it's either too technical or vague for most users to understand. Errors like #REF!, #VALUE!, etc. are common but hard to understand. Gemini in Google Sheets should now act as a bridge to solve these errors, so you can focus on getting your work done. If you spend all day in Google Sheets, this new Gemini capability should help you create more complex formulas without having to worry about errors. Google says Gemini will help you with all kinds of formulas, from simple to complex equations. Rolling out now with enhanced limits The enhanced Gemini experience in Google Sheets is rolling out now for Business, Enterprise, Education, AI Pro, and AI Ultra users. In its announcement, Google also notes that until July 15, 2026, it is giving users higher limits to experience the improved Gemini in Google Sheets. After that, per-usage limits will apply, with the company providing more details before the limits go into effect. Post July 15, 2026, only users with the AI Expanded Access licenses will have higher usage limits. This upgrade arrives just over a month after Google added support for custom instructions in Gemini for Google Docs, allowing users to tailor the AI assistant to their specific needs.

Google Sheets gets a Gemini upgrade that's actually useful

When not writing, Dave enjoys spending time with his family, running, playing the guitar, camping, and serving in his community. His favorite place is the Blue Ridge Mountains, and one day he hopes to retire there (hopefully his fear of heights will have retired by then, too!). * Gemini in Sheets adds a Fix button that diagnoses formula errors. * The tool doesn't just provide the correct formula -- it also shows you what was wrong, so you can learn from your mistakes. * The feature is rolling out now on select Google Workspace and AI plans. On June 22, Google announced new Gemini features for Google Sheets. Unlike many of the AI-powered updates we've seen, though, this actually looks helpful. I finally stopped writing messy Google Sheets formulas thanks to this one function Readable enough to survive time, teammates, and future you. Posts 1 By Adaeze Uche Useful upgrades for Gemini in Sheets Formulas made easier Formulas are one of the most powerful functions in spreadsheets, whether Google Sheets or Excel. Even simple functions like QUERY can save you hours of manual work. However, writing formulas can be tricky, and all too often you end up seeing a cryptic error message instead of the expected output. If you're not already a formula pro, you can end up spending a ton of time troubleshooting. While that's sometimes the best way to learn, it's also not something you always have time for. The latest Gemini update to sheets aims to help solve that problem. Now, when your formula encounters an error, a Fix button will appear. Click it, and Gemini will review the formula, diagnose the problem, and provide the correct formula. Gemini doesn't just look at the formula -- it also considers the surrounding cells and context. The aim is to remove "the barrier to writing complex formulas for advanced analysis right where you work." Notably, Gemini doesn't just fix the formula for you. Instead, it "provides an easy-to-understand explanation of the core issue." This means it actually doubles as a learning tool -- you can see what you did wrong and hopefully correct the issue next time. Of course, if you just want the right formula, that's there, too. Feature availability Rolling out Google-style The new Gemini features are rolling out now, but the rollout is gradual. Google says it could take up to 15 days for the feature to show up on your account, so if you don't see it right away, keep checking. While you're waiting, be sure to check out the other useful features in Sheets. It's available for users on the following Google plans: * Business Standard and Plus * Enterprise Standard and Plus * Google AI Pro and Ultra * Google AI Pro for Education * AI Expanded Access Google says that, through July 15, Google Workspace customers will get "promotional access to higher limits for the improved Gemini in Sheets experience." The goal here is to let people test the functionality. Unfortunately, after July 15, usage limits will be in place. Google Sheets Google Sheets is a cloud‑based spreadsheet tool that lets you organize, analyze, and collaborate on data in real time. See at Google Sheets Expand Collapse

Gemini's New Google Sheets Trick Fixes Your Formula Headache in One Click

Anyone who's used Google Sheets has hit that wall. You build a formula that looks right, then a #REF! or #VALUE! pops up with no explanation. The usual fix means squinting at the formula bar, then searching the error code. Maybe you ask a chatbot, but it can't see your sheet either. Google just rolled out a Gemini Sheets formula fix that diagnoses and corrects errors in one click, right where they happen. According to Google's Workspace blog, Gemini analyzes the surrounding data, then explains the issue in plain language alongside a corrected formula. Why this matters beyond saving time Sheets has always been somewhat intimdating for anyone new to spreadsheets. Some formulas, especially more complex ones, take real effort to learn. One stray comma turns a working formula into gibberish. That hurdle keeps plenty of people out of Sheets entirely and stick to manual entry instead. This Gemini Sheets formula fixes that in a way generic AI chat never managed. The fix happens inside the same tab where the error showed up. There's no copying a formula into a chat window and hoping the explanation matches your sheet. You click. The explanation shows up in plain English, and the formula corrects itself. That's it. Google says the fix is rolling out now through July 15. It's available to Business Standard, Enterprise, and Google AI Pro and Ultra subscribers. Usage limits for the Gemini Sheets formula fix loosen during that window. The harder functions in Sheets were never about syntax. They were about feeling like you needed a manual for a tool everyone else picked up instantly. Gemini just deleted that feeling.