HomeWinBuzzer NewsGoogle Sheets Receives Automatic Formula Corrections

Google Sheets Receives Automatic Formula Corrections

The ability for Google Sheets to automatically correct formulas comes a year after a tool for suggesting formulas went live.

-

Despite the ongoing dominance of Office 365 in the enterprise space, Workspace has made in-roads and is especially popular with education and individuals. So, for millions of people, is their go-to spreadsheet software and not Microsoft Excel. If you are one of those users, Sheets is getting a handy new update.

For the latest rollout to Google Sheets, the web app is getting the ability to automatically correct formulas within a spreadsheet.

This feature is a natural evolution from the ability to automatically suggest formulas, which came to Sheets last year. Adding the ability to also correct formulas allows users to easily create complex mathematical calculations.

Google points out that formula corrections are powered by AI and are context-aware. If Sheets detects a formula, you write can be improved, it will provide a suggestion in a dialogue box with recommended changes and details explaining those changes.

Details

Users can accept or dismiss the suggestion. Google's GIF (below) shows the feature in action:

One obvious question about this feature is how advanced can it get? In other words, how many formulas can it fix? Google hasn't said specifically, but as it is AI-driven, I guess it will improve in the future as it learns.

Sheets has formula corrections on by default, so you will need to disable it if you're not interested. To do that, head to Tools > Enable formula corrections and switch the toggle to off. Google is rolling the tool out in stages, but it should come to all Workspace and personal users in the coming weeks.

Tip of the day: To prevent attackers from capturing your password, Secure Sign-in asks the user to perform a physical action that activates the sign-in screen. In some cases, this is a dedicated “Windows Security” button, but the most common case in Windows is the Ctrl+Alt Del hotkey. In our tutorial, we show you how to activate this feature.

Luke Jones
Luke Jones
Luke has been writing about all things tech for more than five years. He is following Microsoft closely to bring you the latest news about Windows, Office, Azure, Skype, HoloLens and all the rest of their products.

Recent News