• Latest News

    Friday, October 16, 2020

    Google Sheets Gets Smart Fill, to Help with Data Entry

    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.

    Announcing the new feature in a blog post, Google said that Smart Fill will make data entry on Google Sheets quicker, similar to how Smart Compose helps users write faster with fewer mistakes. If you have a column of full names, you may want to split it into a column with the first names and another with the last names. Smart Fill will automatically look for patterns and will generate the corresponding formula, going on to autocomplete the rest of the column.

    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.

    • Blogger Comments
    • Facebook Comments


    Item Reviewed: Google Sheets Gets Smart Fill, to Help with Data Entry Rating: 5 Reviewed By: BrandIconImage
    Scroll to Top