Smart Fill feature comes to Google Sheets

Similar to Smart Compose in Gmail, Smart Fill makes data entry quicker and less error-prone in Google Sheets. For instance, if you want to split a column of full names into two columns ( say first and last name), as you start typing first names into a column, Sheets will automatically detect the pattern, generate the corresponding formula, and then autocomplete the rest of the column.

Devdiscourse News Desk | California | Updated: 16-10-2020 11:06 IST | Created: 16-10-2020 11:06 IST
Smart Fill feature comes to Google Sheets
Image Credit: Google

Google has added a new Smart Fill feature to Sheets which detects and learns patterns between columns to intelligently auto-complete data entry.

Similar to Smart Compose in Gmail, Smart Fill makes data entry quicker and less error-prone in Google Sheets. For instance, if you want to split a column of full names into two columns ( say first and last name), as you start typing first names into a column, Sheets will automatically detect the pattern, generate the corresponding formula, and then autocomplete the rest of the column.

GIF Credit: Google

"We hope that Smart Fill will make it easier to prepare and use data in Sheets. By adding new, intelligent features to help automate data preparation and analysis, we hope to empower all users to harness the power of data and quickly make data-backed decisions," Google wrote in a blog post.

Further, Sheets Smart Fill can also use data from Google's Knowledge Graph, the database of billions of facts about people, places, and things and for Enterprise Plus customers, it can also use information from the company's people Directory to autocomplete data.

The default feature has started rolling out to the Rapid Release domains while Scheduled Release domains will get it starting November 5, 2020. The Sheets Smart Fill feature is available to Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education, Enterprise for Education, and Nonprofits customers, and users with personal Google Accounts.


TRENDING

OPINION / BLOG / INTERVIEW

Blockchain in Healthcare: Opportunities and challenges

The use of blockchain in healthcare is a relatively new innovation with many of its uses still being explored and related technologies being developed, improved, and scaled. ...

Debate surrounding vaccine passports and development misses bigger picture

... ...

Blockchain vs IOTA: Looking for a better alternative

... ...

For stability, Iraq needs to crack down on corruption

... ...

Videos

Latest News

Second Covid wave seems to have flattened but won’t end before July: virologist Shahid Jameel  

Indias second COVID-19 wave seems to have flattened but the climb down will be a more prolonged, long drawn-out process than the first and will possibly run till July, says eminent virologist Shahid Jameel.Though the new variants of the vir...

What you need to know about the coronavirus right now

Heres what you need to know about the coronavirus right now Record number of deaths in IndiaIndia said on Wednesday a record number of people were killed by the coronavirus in the past 24 hours, pushing its overall death toll over a quarter...

The Seven Deadly Sins Season 5: Why Netflix is silent on it?

The avid viewers of The Seven Deadly Sins are waiting for the release of Season 5. The fifth seasons release was initially planned in October 2020 in Japan but it was delayed later due to the prevailing Coronavirus pandemic.The Seven Deadly...

SC dismisses plea of activist Gautam Navlakha seeking bail in Elgar Parishad-Maoist link case of Bhima Koregaon.

SC dismisses plea of activist Gautam Navlakha seeking bail in Elgar Parishad-Maoist link case of Bhima Koregaon....

Give Feedback