Google Sheets Now Automatically Correct Formulas For You

Google Sheets is one of the best online tools for managing spreadsheets. Every now and then, the search engine titan introduces new features to improve the experience of Google Sheets. Now, the company has released an update, which will now automatically correct formulas for the users in their online spreadsheets.

Google Sheets Gets Intelligent Corrections For Formulas

The latest update for Google Sheets allows the users to utilize formulas faster and with higher confidence, thanks to auto formula corrections. Now, whenever a user will insert a flawed formula inside the spreadsheet, the new feature will display a suggestion with the correct one. The new intelligent, context-aware Sheets feature will show a suggestion box with an improved and new version of the formula.

In the official blog post, Google has mentioned some examples that will be automatically corrected by the new feature. These include "VLOOK UP errors, missing cells in range input, and locking ranges when applying formulas across cells". Notably, users will have the option to simply accept or reject the newly suggested formula by the Sheets. Google has added short animation on the workplace website that shows how to new feature works.

Google Sheets Auto Formula Correction Feature Availability Details

As per the company, the new auto formula correction is now live for all Google Workspace users, apart from Legacy G Suite and Business users. Even the personal Google account owners will also be able to take advantage of the new feature. The new functionality for Google Sheets is currently being pushed to all users in a gradual manner. So it could take a couple of weeks to reach all the consumers.

Furthermore, the auto formula correction feature of Google Sheets will be available by default. However, the users will also have a choice to disable the same by going to Tools>Enable formula corrections. In addition, there's an option to disable the feature by hitting the three-dot menu of the newly introduced suggestion dialog box.

The intelligent correction for formulas in Google Sheets is an improved version of the formula suggestions that the brand introduced last year. However, it was limited to certain formulas and specific cells. Essentially, the latest update brings improved context-aware suggestions that help Sheets users to troubleshoot and improve many more different kinds of formulas.