This Google Sheets Gemini upgrade is perfect for those who hate spreadsheets


Google is giving Gemini in Sheets a genuinely practical new trick. It can now help users figure out why a formula isn’t working and suggest a fix automatically.

The feature is rolling out now and tackles one of the most common frustrations in spreadsheets. While Gemini could already generate formulas for users, it wasn’t much help when something broke after a formula was entered manually. That’s now changing. Gemini is now able to analyse both the formula and the surrounding cells to explain what went wrong and how to fix it.

When Sheets detects a formula error, users will now see a new Fix button. Clicking it opens the Gemini sidebar. In this sidebar, the AI explains the issue in plain language and suggests a corrected version of the formula.

That might sound like a small change, but anyone who spends a lot of time in spreadsheets will know how cryptic errors like #REF!, #VALUE!, and #N/A can be. Sheets already flags these issues. However, the explanations are often either too technical or too vague to be particularly useful.

Google says Gemini can bridge that gap by translating spreadsheet jargon into something easier to understand. Rather than sending users to a support page or forcing them to search for answers online, the AI can identify the problem directly within the spreadsheet. It can also recommend a solution.

Advertisement

The company also says the tool can help with everything from simple calculations to more advanced formulas. This potentially makes it easier for users to build complex spreadsheets without worrying about breaking them.

Importantly, this feels like the kind of AI feature that solves a real problem rather than creating a new workflow. Many recent Gemini additions have focused on generating content or automating tasks. However, spreadsheet troubleshooting is something users regularly run into, especially in business and education environments.

The upgraded Gemini experience is rolling out now to Business, Enterprise, Education, AI Pro, and AI Ultrasubscribers.

Google is also temporarily increasing usage limits until 15 July 2026, giving users more opportunities to try the new functionality. After that date, standard usage limits will return, with expanded allowances reserved for users on AI Expanded Access licences.

The update arrives just over a month after Google added custom instructions to Gemini in Docs. This suggests the company is continuing to push its AI tools deeper into Workspace.

Advertisement



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews






It’s easy to assume that vehicles all had internal combustion engines until very recently. Gasoline and petrol engines were the standard for decades, after all, so why would early vehicles be any different? In reality, the early days of the automobile era were more varied than you might expect, and even featured a range of electric cars. Yes, despite electric vehicles not truly taking off until the 21st century, the first electric vehicles are much older than you think; drivers in the 1900s were going around town in electric vehicles — and where there are EVs, there are charging stations.

One such station, visible in the image above, was the creation of General Electric. Formally called the mercury arc rectifier, it took alternating current and sent it through vaporized mercury in a glass tube. This converted it into direct current, which powered up the EV’s battery. The woman in the image, who’s charging a Columbia Mark 68 Victrola, is standing at the control panel, which allowed a user to adjust power levels. 

These chargers could be installed everywhere, including homes, businesses, and public parking garages, supporting the electric vehicle boom of the early 20th century. While 21st-century EV chargers have come a long way from where they were, the basic building blocks are all still there, and it’s fascinating to see.

How EV chargers have evolved since the early 20th century

EV charging has changed a lot in some ways — but not in others. At the core of it all is the aforementioned conversion from AC to DC, which still happens when you charge modern EVs at standard charging stations. The difference is that your vehicle’s on-board charger performs the conversion, not the charger. Old EV chargers took between several hours and a day to charge, and current-day units can similarly take a few hours to well over a day from empty, depending on the charger’s speed. Fast chargers, which provide DC directly, can cut this down to around an hour or less.

Old-school and modern EV chargers also differ in how they provide power to the vehicle. Mercury arc rectifiers connected directly to the negative terminal of the lead-acid battery that needed charging. Nowadays, EVs use dedicated charging ports. Battery swapping was also commonplace in the early 1900s, and companies like General Electric tried to cash in by offering to replace drivers’ old, run-down batteries with new ones for a fee. That’s not yet possible with most mainstream EVs, although companies like Stellantis have tried to introduce EV battery swapping with moderate success.

Even if they were unrefined compared to today’s models, early EVs seemed to be on to something. Why, then, did electric cars fail, and how did gasoline end up becoming the predominant power source for vehicles?

What led to the downfall of the original wave of electric cars

EVs were no mere fad in the 1900s and 1910s. According to the 1900 United States census, 1,575 of the 4,192 vehicles sold that year were electric, with the value of these early EVs — $2,873,464 — accounting for more than half of the total market value of $4,899,443. It wasn’t just EVs, either; other sources of propulsion, like steam, were also vying for a foothold in the automobile market. By the 1920s and 1930s, though, these had all been superseded by the internal combustion engine.

One of the major drawbacks of early EVs was the fact that electricity was not yet widely available. Electrical hookups were a rarity outside of major cities, limiting the use of these vehicles. The lead-acid batteries they used also had their fair share of issues. They needed to be inspected, cleaned, and repaired every few days, making them more of an inconvenience than anything. Worse yet, they had poor mileage, and, with chargers possibly out of reach, many likely didn’t want to risk being stranded while out for a drive.

Eventually, price reductions for gas cars and improvements such as electric starters and better reliability prompted buyers and automakers alike to move away from electric rides. Thus, while the best-selling EVs of 2026 show that it’s a good time for EVs, this electric boom plainly isn’t the first of its kind. Early EVs eventually fizzled out, but they still set the stage for our current fascination with electric vehicles.





Source link