Despite the ongoing dominance of Microsoft Office 365 in the enterprise space, Google Workspace has made in-roads and is especially popular with education and individuals. So, for millions of people, Google Sheets 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.
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.