Google Sheets is getting an update that will make easier for it to suggest like in-line, sequential, context-aware suggestions for formulas and functions. This formula suggestions will help analyse data much quicker.
This feature started rolling out for users on 25th August 2021 and it has a gradual rollout schedule.
Google said that it trained a machine learning (ML) model with anonymised data from spreadsheets to help create these formula suggestions.
This update for Google Sheets was announce through a blog post.
They mentions that the new formula suggestions will make it easier to “write new formulas accurately and help make data analysis quicker and easier.”
Google mentions that by simply inserting a formula in Sheets, suggestions will be automatically display while a user is typing in the cell.
This will also show additional incremental suggestions in the drop-down menu.
The new formula suggestion tool will be available for all Google Workspace, G Suite Basic, G Suite Business, and Personal users.
Google will conduct a gradual rollout and it will take up to 15 days for all users to receive the new feature.
When update received then users can activate it by going to Tools > Enable formula suggestions.
Also formula suggestion can also be activate from the three-dot menu of the suggestion dialogue box.
THANK YOU FOR READING.