When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works.

Google Sheets will now automatically correct formulas for you

A screenshot of Google Sheets Monthly Budget template with a logo on the right

Although people with access to Microsoft 365's Office suite of applications tend to use Excel Online when they want to use spreadsheet software on the web, another alternative to consider is Google Sheets too. Google regularly updates Sheets with new features and capabilities to entice more customers. Now, it has empowered Sheets to autonomously and intelligently correct formulas for you.

This capability follows a related one from last year where Google Sheets would automatically suggest formulas to you. The latest update for formula corrections now helps you write complex mathematical and logical calculations with more confidence.

Formulas corrections are context-aware and enable users to troubleshoot with ease too. Basically, whenever Sheets detects that a formula can be improved, it will offer you a suggestion box with the recommended changes and the associated details. You can then choose to accept or reject the recommendation. Check out the functionality in action in the GIF below:

A GIF showing intelligent formula corrections in Google Sheets

Although Google hasn't detailed an extensive list of formulas that Sheets can intelligently correct for you, some examples include VLOOKUP errors, missing cells in input range, and locking of ranges when applying formulas across a series of cells. The capability will likely improve with time.

Formula corrections will be enabled by default, but people who don't want it can head over to Tools > Enable formula corrections to toggle it off. The functionality is available for Google Workspace, G Suite, and Google personal accounts, but it may take several weeks for it to appear generally for these customers.

Report a problem with article
Halo Infinite Season 2 map
Next Article

Here's a first look at Catalyst and Breaker maps coming to Halo Infinite

The Microsoft and Microsoft Defender logos over a black background
Previous Article

AV-Comparatives finds Microsoft Defender has one of the poorest offline detection rates

Join the conversation!

Login or Sign Up to read and post a comment.

9 Comments - Add comment