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

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.

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. 

TechRadar – All the latest technology news

Read More

Google Sheets are about to become even more chaotic and unwieldy

A new era of gargantuan Google Sheets could be coming thanks to a new change made by the company.

In a Google Workspace update blog, the company revealed that it was increasing the cell limit in its spreadsheet software from up to five million cells to up to ten million cells.

The new limit isn't just for newly-created files either, with Google noting that it will also be available for existing and imported files, meaning you can expand to your heart's content. 

Giant Google Sheets

“Over the course of the last four years, we’ve been steadily increasing the cell limit in Google Sheets: from 2 million to 5 million in 2019 and now to 10 million,” the blog post read. “We hope this and future increases give users the ability to work with their data on a much greater scale in Google Sheets.”

The update is rolling out now to all users, and won't require any special admin control or action to activate. It's available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers.

The feature is the latest in a series of recent updates to Google Sheets as it looks to boost its offerings for hybrid workers.

This includes the recent addition of intelligent formula suggestions based on the data in question and the user’s initial input, taking much of the heavy lifting out of complex formulae.

The software itself also recently saw a cosmetic overhaul to make Google Sheets better for users with smaller screens. The changes saw the menu bar, as well as the right-click menu shortened to better fit on a smaller screen, and to prevent menu items from being hidden off-screen.

Some features were also reorganized and moved to “more intuitive” locations. For example, freezing a row or a column can now be done directly from the right-click menu. Menu items also received new icons, while the descriptions of some items in the menu are shorter.

TechRadar – All the latest technology news

Read More