The company has launched “intelligent corrections” for formulas in Google Sheets, context-aware fixes that it says help you improve and troubleshoot many different kinds of formulas.
Google Sheets formulas
Going forward, when writing a formula into Sheets, the new feature will analyze it and see if any improvements could be made. If so, a suggestion box will appear with details on a new version that can replace the current formula, including the ability to accept or reject it.
Google says the new addition can help with a number of common formula issues, including VLOOKUP errors, missing cells in range input, and locking ranges when applying formulas across cells.
The new feature is rolling out now, and will be enabled by default for all Google Workspace customers, as well as legacy G Suite Basic and Business customers, and users with personal Google Accounts. It can be disabled if it proves too much of a hindrance, by going to Tools > Enable formula corrections or from the three-dot menu of the suggestion dialog box.
The announcement follows a similar update in August 2021 which saw Google Sheets introduce intelligent formula suggestions, with the program able to offer ideas based on the data in question and the user’s initial input.
Google said that the new formula suggestions will make it easier to write new formulas accurately and help make data analysis quicker and easier.
The company also recently revealed that it was increasing the cell limit in Google Sheets from up to five million cells to up to ten million cells.
The new limit isn't just for newly-created files either, but also existing and imported files, meaning you can expand to your heart's content.