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.
229 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
229 Shares
Share
Tweet
Share

Popular on Engadget

Canon takes on Sony's A7 series with the full-frame EOS R6 camera

Canon takes on Sony's A7 series with the full-frame EOS R6 camera

View
Amazon has eliminated single-use plastic at its Indian fulfilment centers

Amazon has eliminated single-use plastic at its Indian fulfilment centers

View
Probe of failed Boeing Starliner launch finds a long list of problems

Probe of failed Boeing Starliner launch finds a long list of problems

View
Dell's XPS Desktop fits NVIDIA and AMD graphics inside a smaller case

Dell's XPS Desktop fits NVIDIA and AMD graphics inside a smaller case

View
Logitech pulls support for Harmony Express remote a year after launch

Logitech pulls support for Harmony Express remote a year after launch

View

From around the web

Page 1Page 1ear iconeye iconFill 23text filevr