Before we talked about how Google sheets is getting smarter. And finally in the last update from Google, now we can use smart fill in Google sheets.
Google said:
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.
Smart fill 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.
Also, Smartfill integration with people directory is only available to Enterprise Plus customers.