{"id":90537,"date":"2020-10-16T09:44:21","date_gmt":"2020-10-16T06:44:21","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/google-sheets-new-smart-autofill-will-save-you-precious-time-entering-data\/"},"modified":"2020-10-16T09:44:21","modified_gmt":"2020-10-16T06:44:21","slug":"google-sheets-new-smart-autofill-will-save-you-precious-time-entering-data","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/google-sheets-new-smart-autofill-will-save-you-precious-time-entering-data\/","title":{"rendered":"#Google Sheets\u2019 new Smart Autofill will save you precious time entering data"},"content":{"rendered":"<p>&#8220;<strong>#Google Sheets\u2019 new Smart Autofill will save you precious time entering data<\/strong>&#8221;<\/p>\n<div>\n                                <span>Google\u2018s Smart Compose feature in Gmail has helped me a lot, from autofilling names to completing sentences and saving me time<\/span>. Now, the company is <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/workspaceupdates.googleblog.com\/2020\/10\/smart-fill-google-sheets-automate-data-entry.html\">rolling out similar technology<\/a>\u00a0in its <del>GSuite<\/del> Google Workplace product, Google Sheets.<\/p>\n<p>There are a couple of things you can do through the new Smart fill feature in Google Sheets. If you have a column with full names, and you\u2019re making one with last names, it\u2019ll suggest formula as soon as you type the first entry. Similarly, if you have a column for a postal address, and you\u2019re creating another with postcodes, the new smart autofill will pick up these codes after you key in the first entry.<\/p>\n<p><em>[Read:\u00a0Google now lets you hum to find that song stuck in your head]<\/em><\/p>\n<p><span>This\u2019ll come in handy when you\u2019re preparing a list of people to send out invites or holiday greetings, for example<\/span>. You can see the new feature in action in the GIF below.<\/p>\n<figure class=\"post-image post-mediaBleed aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1323889 lazy\" alt=\"\" width=\"639\" height=\"408\" src=\"https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2020\/10\/smartfill-in-sheets.gif\" data-lazy=\"true\"\/><figcaption><a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/thenextweb.com\/plugged\/2020\/10\/16\/google-sheets-new-smart-autofill-will-save-you-precious-time-entering-data\/#\" data-url=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fthenextweb.com%2Fplugged%2F2020%2F10%2F16%2Fgoogle-sheets-new-smart-autofill-will-save-you-precious-time-entering-data%2F&amp;via=thenextweb&amp;related=thenextweb&amp;text=Check out this picture on: Smartfill in Google Sheets\" data-title=\"Share Smartfill in Google Sheets on Twitter\" data-width=\"685\" data-height=\"500\" class=\"post-image-share popitup\" title=\"Share Smartfill in Google Sheets on Twitter\"><i class=\"icon icon--inline icon--twitter--dark\"\/><\/a>Smartfill in Google Sheets<\/figcaption><\/figure>\n<p>In addition to understanding the context of the sheet, it can also fetch data from publically available data, such as cities in a country, from the Google Knowledge Graph. Plus, if you\u2019re an enterprise customer, you can also fill in data from your company\u2019s address book.<\/p>\n<p>Google says that this feature will roll out to all users by November 5 and it\u2019ll be turned on for all users by default.<\/p>\n<p><i>For more gear, gadget, and hardware <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/news\/\" data-internallinksmanager029f6b8e52c=\"2\" title=\"News\" target=\"_blank\" rel=\"noopener\">news<\/a> and reviews, follow Plugged on<br \/>\n            <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/twitter.com\/plugged\">Twitter<\/a> and<br \/>\n            <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/flipboard.com\/@thenextweb\/plugged-54nihknvy\">Flipboard<\/a>.<br \/>\n            <\/i><\/p>\n<p class=\"c-post-pubDate\">\n                                    Published October 16, 2020 \u2014 06:44 UTC\n                                <\/p>\n<\/p><\/div>\n<p><script async src=\"\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><script data-src=\"https:\/\/connect.facebook.net\/en_US\/sdk.js#xfbml=1&amp;appId=378011798897423&amp;version=v2.6\" id=\"socialSrcFacebook\" type=\"text\/template\"><\/script><\/p>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/thenextweb.com\/plugged\/2020\/10\/16\/google-sheets-new-smart-autofill-will-save-you-precious-time-entering-data\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#Google Sheets\u2019 new Smart Autofill will save you precious time entering data&#8221; Google\u2018s Smart Compose feature in Gmail has helped me a lot, from autofilling names to completing sentences and saving me time. Now, the company is rolling out similar technology\u00a0in its GSuite Google Workplace product, Google Sheets. There are a couple of things you&#8230;<\/p>\n","protected":false},"author":1,"featured_media":90538,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/img-cdn.tnwcdn.com\/image\/plugged?filter_last=1&fit=1280,640&url=https:\/\/cdn0.tnwcdn.com\/wp-content\/blogs.dir\/1\/files\/2020\/10\/Google-sheets.jpg&signature=3352d1a769d08b59f3a4b1a9755bd9f7","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-90537","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/90537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=90537"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/90537\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/90538"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=90537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=90537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=90537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}