Google Sheets is looking to help spreadsheet users around the world with the launch of a new tool that will let you write formulas better and faster.

The company has released "smart fixes" for formulas in Google Sheets, pop-up fixes it says help you improve and fix problems with many types of formulas.

"Now you can write formulas faster and more confidently with Formula Corrections," the company wrote in a Google Workspace blog post announcing the news.

Google Sheets Formulas

In the future, when you type a formula in Sheets, the new feature will analyze it and see if improvements can be made. If so, a suggestion box will appear with details about a new version that can replace the current formula, including the option to accept or reject it.

Google says the new addition can help fix a number of common formula issues, including VLOOKUP errors, missing cells in range input, and locked ranges when applying formulas to multiple cells.

The new feature is rolling out and will be enabled by default for all Google Workspace customers, as well as G Suite Basic and Business customers and legacy users with personal Google accounts. It can be disabled if it is too inconvenient by going to Tools > Enable formula fixes or from the three-dot menu in the suggestion dialog.

The announcement follows a similar update in August 2021 in which Google Sheets introduced smart formula suggestions, with the program able to generate ideas based on the data in question and initial user input.

Google said the new formula suggestions will make it easier to write new formulas accurately and help make data analysis faster and easier.

The company also recently revealed that it is increasing the cell limit in Google Sheets from five million cells to ten million cells.

The new limit affects not only newly created files, but also existing and imported files, meaning you can expand as you see fit.

Share This