Latest in Gear

Image credit: Google

Google Sheets will soon suggest formulas as you type

It will also use machine learning to clean up your spreadsheets.
234 Shares
Share
Tweet
Share

Sponsored Links

Smart Fill demo
Google

Spreadsheet programs like Microsoft Excel and Google Sheets can be powerful tools if you're a wizard with formulas, but learning all the ins-and-outs of those apps can be time-consuming. If you only use Sheets sparingly, Google is adding two features that will save you some time the next time you need to work on a project (via TechCrunch). 

The first, Smart Fill, takes a page from the company's Smart Compose functionality in Gmail and Docs. You can see the feature in action in the GIF above. When Smart Fill detects a pattern of usage, it will attempt to complete that part of the document automatically. 

What's nifty about Smart Fill is that anytime it does its thing, it creates a formula instead of adding data without user input. That's something that gives you control over how it works since you can tweak its suggestion as needed. It's also an opportunity to learn how formulas work in Sheets, allowing you to use them on your own in the future.

Sheets Smart Cleanup
Google

Another new feature that's coming to the app is Smart Cleanup. As you might have guessed from the name, Smart Cleanup will detect duplicate rows, as well as any other formatting issues, and suggest a fix. 

This isn’t the first time Google has used machine learning to make Sheets easier to use. In 2017, the company added natural language recognition to the app’s “Explore” tool. You’ll have to wait a bit to use the company’s latest new features, however; Google plans to add Smart Fill to Sheets later this year. 

All products recommended by Engadget are selected by our editorial team, independent of our parent company. Some of our stories include affiliate links. If you buy something through one of these links, we may earn an affiliate commission.
Comment
Comments
Share
234 Shares
Share
Tweet
Share

Popular on Engadget

‘Babylon 5 Remastered’ now available to buy, or stream on HBO Max

‘Babylon 5 Remastered’ now available to buy, or stream on HBO Max

View
iOS 14.4 rolls out with Bluetooth audio monitoring

iOS 14.4 rolls out with Bluetooth audio monitoring

View
Sony's A1 is a $6,500 50MP camera that shoots 30fps bursts and 8K video

Sony's A1 is a $6,500 50MP camera that shoots 30fps bursts and 8K video

View
Chrome OS 88 turns your Chromebook into an impromptu smart display

Chrome OS 88 turns your Chromebook into an impromptu smart display

View
The East Coast suffered major internet connection issues this afternoon

The East Coast suffered major internet connection issues this afternoon

View

From around the web

Page 1Page 1ear iconeye iconFill 23text filevr