Skip to content

XploreME

The Ultimate Tech News Scrapper

  • Home
  • Technology
  • Google Sheets Can Now Suggest Formulas, Functions Automatically
  • Technology

Google Sheets Can Now Suggest Formulas, Functions Automatically

xploreme August 27, 2021 2 min read


Google Sheets is getting an update that will make it easier for it to suggest “in-line, sequential, context-aware suggestions for formulas and functions.” The search giant notes that these formula suggestions will help analyse data much quicker. The feature started rolling out for users on August 25 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.

The update for Google Sheets was announced through a blog post. It 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 displayed while a user is typing in the cell. It will also show additional incremental suggestions in the drop-down menu.

Google told the Verge that Google Sheets suggestions can also identify headers and analyse how data is grouped to get an idea of what to suggest to the users.

The new formula suggestion tool will be available for all Google Workspace, G Suite Basic, G Suite Business, and Personal users. As mentioned, the update for Google Sheets started rolling out on August 25. Google will conduct a gradual rollout and it will take up to 15 days for all users to receive the new feature. Gadgets 360 was able to view the feature on the app. Once received, users can activate it by heading to Tools > Enable formula suggestions. Alternatively, formula suggestion can also be activated from the three-dot menu of the suggestion dialogue box.

Back in June, to celebrate Pride month, Google Sheets added a fun easter egg that transformed a plain white spreadsheet to showcase the Rainbow flag. If you type ‘PRIDE’ across the Google Sheet columns, you should be able to spot the easter egg.

 

For the latest tech news and reviews, follow Gadgets 360 on Twitter, Facebook, and Google News. For the latest videos on gadgets and tech, subscribe to our YouTube channel.


Satvik Khare is a sub-editor at Gadgets 360. His proficiency lies in educating how technology makes life easier for everyone. Gadgets have always been a passion with him and he’s frequently found finding his way around new technologies. In his free time he loves tinkering with his car, participating in motorsports, and if the weather is bad, he can be found doing laps on Forza Horizon on his Xbox or reading a nice piece of fiction. He can be reached through his Twitter
…More

Redmi 10 Prime Confirmed to Come With MediaTek Helio G88 SoC

Shang-Chi Final Trailer Out Now in Hindi, Tamil, Telugu, and Kannada

Related Stories





Source link

Tags: g suite google sheets google sheets formula function automatic suggestion workspace g suite basic business personal account rollout google google workspace

Continue Reading

Previous: Redmi 10 Prime Will Come With MediaTek Helio G88 SoC
Next: WhatsApp may soon announce new terms of service, here’s what you will not be able to do if you don’t accept – Times of India

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Related Stories

iPhone 14 Production, Shipment Schedule Unaffected by Geopolitics: Report
2 min read
  • Technology

iPhone 14 Production, Shipment Schedule Unaffected by Geopolitics: Report

August 10, 2022
Toshiba Outlines Plans to Boost Sales, Reports Rise in Quarterly Profit
2 min read
  • Technology

Toshiba Outlines Plans to Boost Sales, Reports Rise in Quarterly Profit

August 10, 2022
Samsung Galaxy Z Flip 4 With Snapdragon 8+ Gen 1 SoC Launched: All Details
3 min read
  • Technology

Samsung Galaxy Z Flip 4 With Snapdragon 8+ Gen 1 SoC Launched: All Details

August 10, 2022

You may have missed

iPhone 14 Production, Shipment Schedule Unaffected by Geopolitics: Report
2 min read
  • Technology

iPhone 14 Production, Shipment Schedule Unaffected by Geopolitics: Report

August 10, 2022
Toshiba Outlines Plans to Boost Sales, Reports Rise in Quarterly Profit
2 min read
  • Technology

Toshiba Outlines Plans to Boost Sales, Reports Rise in Quarterly Profit

August 10, 2022
Samsung Galaxy Z Flip 4 With Snapdragon 8+ Gen 1 SoC Launched: All Details
3 min read
  • Technology

Samsung Galaxy Z Flip 4 With Snapdragon 8+ Gen 1 SoC Launched: All Details

August 10, 2022
Spotify Rolls Out Redesigned Home With Music, Podcast Feeds: Details
2 min read
  • Technology

Spotify Rolls Out Redesigned Home With Music, Podcast Feeds: Details

August 10, 2022
| DarkNews by AF themes.