Skip to content

Use Smart Fill to help automate data entry in Google Sheets

What’s changing 

We’re launching Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently autocomplete data entry. 

For example, if you have a column of full names, you may want to split it into a column with first names and a column with last names. As you start typing first names into a column, Sheets will automatically look for patterns. If Sheets detects a pattern, it will generate the corresponding formula, and then autocomplete the rest of the column for you. 

Who’s impacted 

End users 

Why it’s important 

We hope that Smart Fill will make it easier to prepare and use data in Sheets. Similar to how Smart Compose in Gmail helps you write faster with fewer mistakes, Smart Fill makes data entry quicker and less prone to error. 
We also recently launched Sheets Smart Cleanup, which uses similar intelligence to help prepare and analyze 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. 

Additional details 

In addition to using data that’s in a sheet, Smart Fill can also use data from Google’s Knowledge Graph. For example, it can use public data to autocomplete a list of countries where a list of cities are located. 
For Enterprise Plus customers, it can also use information from your company’s people Directory to autocomplete data. For example, it can use organization-only data to fill in email addresses for company employees. 

Getting started 

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on October 15, 2020 
  • Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on November 5, 2020 

Availability 

  • Smartfill 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 
  • Smartfill integration with people directory is only available to Enterprise Plus customers. 

Resources 

Roadmap 


[ad_2]

Net Universe offers all Google devices with worldwide Delivery Services.
Send us an email to [email protected] for more information or visit https://www.netuniversecorp.com/google.
You can visit our Shop Online

 

On Trend

INTERESTING NEWS

Cybersecurity Campaign in Latin America

Unlock 5 hours of free consulting We are pleased to announce the start of our exciting Cybersecurity Campaign, designed to strengthen your business against ever-evolving

Un líder, por decimocuarta vez

Las amenazas cambian. Sophos sigue siendo reconocido Por decimocuarta vez consecutiva, Sophos ha sido nombrado líder en el Cuadrante Mágico™ de Gartner® 2023 para plataformas

Apple Authorized Reseller

Hello, Apple

We proudly announce that Net Universe has been distingued as Apple Authorized Reseller. This membership is a testament to our ongoing commitment to deliver the