This Google Sheets update should stop you messing up formulas at last

Date:
Fri, 15 Apr 2022 15:05:55 +0000

Description:
Intelligent corrections for formulas in Google Sheets should help spot and correct errors.

FULL STORY ======================================================================

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 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. Read
more

Google Sheets vs Microsoft Excel - pick the right spreadsheet app for you

We've built a list of thebest office softwarearound

Keeping track of your colleagues just got a whole lot easier in Google

Sheets

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 users 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. Looking for something different? Here's our list of the best Microsoft Office alternatives



======================================================================
Link to news story: https://www.techradar.com/news/this-google-sheets-update-should-stop-you-messi ng-up-formulas-at-last/


--- Mystic BBS v1.12 A47 (Linux/64)
* Origin: tqwNet Technology News (1337:1/100)