Google Sheets will soon suggest formulas as you type

This site is reader-supported. When you click through links on our site, we may be compensated.

Smart Fill demo


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


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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.