Google Sheets is looking to help spreadsheet users everywhere with the launch of a new tool that will let you write formulas faster and better.
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.
"Now, you can write formulas faster and with higher confidence with formula corrections," the company wrote (opens in new tab) in a Google Workspace blog post announcing the news.
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.
> Google Sheets vs Microsoft Excel - pick the right spreadsheet app for you (opens in new tab)
> We've built a list of the best office software around (opens in new tab)
> Keeping track of your colleagues just got a whole lot easier in Google Sheets (opens in new tab)
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 (opens in new tab) 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.