Google Sheets is getting an update that will make it easier to suggest “inline, sequential, context-based suggestions for formulas and functions.” The search giant notes that these formula suggestions will help analyze data much faster. The feature began rolling out to users on August 25th and has a gradual release schedule. Google said it trained a machine learning (ML) model with anonymous data from spreadsheets to help create these formula suggestions.
The Google Sheets update was announced via a blog post. He mentions that the new formula suggestions will make it easier to “precisely write new formulas and help make data analysis faster and easier.” Google mentions that by simply entering a formula in Sheets, the suggestions will automatically be displayed as the user types in the cell. It will also show additional incremental suggestions in the dropdown menu.
Google told Verge that Google Sheets suggestions can also identify headers and analyze how data is grouped to get an idea of what to suggest to users.
The new formula suggestion tool will be available to all Google Workspace, G Suite Basic, G Suite Business and Personal users. As mentioned, the Google Sheets update started shipping on August 25th. Google will be rolling it out gradually and it will take up to 15 days for all users to receive the new feature. Gadgets 360 was able to preview the resource in the app. Once received, users can activate it by going to Tools> Enable formula suggestions. Alternatively, formula suggestion can also be activated in the three-dot menu of the suggestion dialog.
In June, to celebrate Pride Month, Google Sheets added a fun Easter egg that turned a plain white sheet to show the rainbow flag. If you type ‘PRIDE’ into the Google spreadsheet columns, you should be able to identify the easter egg.
For the latest technology news and analysis, follow Gadgets 360 on Twitter, Facebook and Google News. For the latest videos on gadgets and technology, subscribe to our YouTube channel.
Redmi 10 Prime confirmed to come with MediaTek Helio G88 SoC