{"id":36415,"date":"2020-07-02T13:10:00","date_gmt":"2020-07-02T13:10:00","guid":{"rendered":"https:\/\/icrowdnewswire.com\/?p=2630992"},"modified":"2020-07-02T13:10:00","modified_gmt":"2020-07-02T13:10:00","slug":"google-sheets-update-will-soon-compose-those-pesky-formulae-for-you","status":"publish","type":"post","link":"https:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/","title":{"rendered":"Google Sheets update will soon compose those pesky formulae for you"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"24\" src=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\" class=\"webfeedsFeaturedVisual wp-post-image\" alt=\"\" style=\"display: block; margin-bottom: 5px; clear:both;max-width: 100%;\" link_thumbnail=\"\" \/><\/p>\n<header>\n<div class=\"byline-social\">\n<p class=\"strapline\">Smart Fill will be able to intelligently autocomplete data in Sheets later this year<\/p>\n<\/div>\n<\/header>\n<section class=\"content-wrapper\">\n<div class=\"box less-space\">\n<div><img decoding=\"async\" class=\" block-image-ads hero-image\" src=\"https:\/\/cdn.mos.cms.futurecdn.net\/r3arVtVaPPboMXo7M6Lqb8-320-80.jpg\" alt=\"\" data-original-mos=\"https:\/\/cdn.mos.cms.futurecdn.net\/r3arVtVaPPboMXo7M6Lqb8.jpg\" data-pin-media=\"https:\/\/cdn.mos.cms.futurecdn.net\/r3arVtVaPPboMXo7M6Lqb8.jpg\" \/><\/div>\n<p><span class=\"credit\">(Image credit: Pexels)<\/span><\/div>\n<div id=\"article-body\" class=\"text-copy bodyCopy auto\">\n<p>Building spreadsheets and analyzing the data they contain is about to get a bit easier in&nbsp;<a class=\"hawk-link-parsed\" href=\"https:\/\/www.techradar.com\/news\/google-sheets-vs-microsoft-excel\" data-component-tracked=\"1\" data-custom-tracking-id=\"4162670236150797300\">Google Sheets<\/a>&nbsp;thanks to several new updates recently announced by Google.<\/p>\n<p>The most interesting of these new features is Smart Fill which will launch later this year. In a similar way to how&nbsp;<a class=\"hawk-link-parsed\" href=\"https:\/\/www.techradar.com\/news\/gmail-is-getting-ai-powered-smart-compose-to-write-your-emails-for-you\" data-component-tracked=\"1\" data-custom-tracking-id=\"1263302574502746000\">Smart Compose<\/a>&nbsp;in Gmail helps users write faster, Smart Fill will be able to detect and learn patterns between columns to intelligently autocomplete data for users. Product manager of G Suite, Ryan Weber provided an example of how Smart Fill will work in a&nbsp;<a class=\"hawk-link-parsed\" href=\"https:\/\/cloud.google.com\/blog\/products\/g-suite\/connected-sheets-is-generally-available\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" data-original-href=\"https:\/\/cloud.google.com\/blog\/products\/g-suite\/connected-sheets-is-generally-available\" data-component-tracked=\"1\" data-custom-tracking-id=\"1438455568567086000\">blog post<\/a>, saying:<\/p>\n<aside class=\"hawk-widget\" data-render-type=\"fte\" data-skip=\"dealsy\" data-widget-type=\"seasonal\" data-widget-id=\"1269197844969267500\" data-result=\"missing\"><\/aside>\n<p>&ldquo;Say you have a column of full names, but you want to split it into two columns (first and last name, for example). 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 for you.&rdquo;&nbsp;<\/p>\n<p>The second intelligent feature coming to Sheets soon is Smart Cleanup which will make data cleanup both faster and more accurate. When you import new data into a spreadsheet, Sheets will provide you with intelligent suggestions in the side panel to help you identify and fix things such as duplicate rows or number-formatting issues. You can also choose to accept or ignore these suggestions.<\/p>\n<h2 id=\"connected-sheets\">Connected Sheets<\/h2>\n<p>In addition to new features coming to Sheets, Google also announced the general availability of Connected Sheets.<\/p>\n<p>This feature connects a&nbsp;<a class=\"hawk-link-parsed\" href=\"https:\/\/www.techradar.com\/news\/google-makes-it-easier-to-move-data-to-its-cloud\" data-component-tracked=\"1\" data-custom-tracking-id=\"6281357200734899000\">BigQuery<\/a>&nbsp;data warehouse with Sheets to allow users to analyze billions of rows and petabytes of data without requiring specialized knowledge of programming languages like&nbsp;<a class=\"hawk-link-parsed\" href=\"https:\/\/www.techradar.com\/best\/sql-online-courses\" data-component-tracked=\"1\" data-custom-tracking-id=\"1789305840250769200\">SQL<\/a>. Unlike with desktop spreadsheet applications, a live connection between BigQuery and Sheets means that your data not only stays fresh but also protected by Google&#8217;s security architecture.<\/p>\n<div class=\"slot-double-height-1-722\">&nbsp;<\/div>\n<p>Several customers have already tested out Connected Sheets through the company&#8217;s beta program and Global Change Manager at PwC, Van Nieuwerburgh explained how the feature makes it easier to work with large amounts of data in a spreadsheet, saying:<\/p>\n<div class=\"slot-interscroller\">\n<div class=\"oxymuyumopevtvrr\">\n<div>\n<div class=\"bordeaux-outer-box interscroller-10-10\">\n<div class=\"bordeaux-inner-box\">\n<div>\n<div id=\"miniscroller\" data-google-query-id=\"COitiY_srOoCFZr6dwodky4HbQ\">\n<div id=\"google_ads_iframe_10518929\/tech_techradar\/trpro\/software_6__container__\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"slot-double-height-0-475\">&nbsp;<\/div>\n<p>&ldquo;If you look at our own adoption dashboarding, it&rsquo;s more than three terabytes of data&mdash;good luck putting that in any spreadsheet. With Connected Sheets, we&rsquo;re not really pulling the data into the spreadsheet, rather it lives in the database where it belongs. The ability to go and so easily analyze and visualize the data is really powerful.&rdquo;<\/p>\n<p>Connected Sheets is now available to all G Suite Enterprise, G Suite Enterprise for Education and G Suite Enterprise Essentials users.<\/p>\n<\/div>\n<\/section>\n<p class=\"tags\">\n<div><strong>See Campaign: <\/strong><a href=\"https:\/\/www.techradar.com\/news\/google-sheets-vs-microsoft-excel\" target=\"_blank\">https:\/\/www.techradar.com\/news\/google-sheets-vs-microsoft-excel<\/a><br \/><b>Contact Information:<\/b><br \/>Anthony Spadafora <\/p>\n<p><b>Tags:<\/b><br \/><a href=\"\"><\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/news-category\/wire\/\" rel=\"category tag\">Wire<\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/global-regions\/united-states\/\" rel=\"category tag\">United States<\/a>, <a href=\"https:\/\/icrowdnewswire.com\/category\/language\/english\/\" rel=\"category tag\">English<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\" alt=\"image\" width=\"400\" height=\"300\" class=\"cwdfimg\" \/><\/div>\n<div>\n<h3>Contact Information:<\/h3>\n<p>Anthony Spadafora <\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"24\" src=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\" alt=\"\">Smart Fill will be able to intelligently autocomplete data in Sheets later this year (Image credit: Pexels) Building spreadsheets and analyzing the data they contain is about to get a bit easier in&nbsp;Google Sheets&nbsp;thanks to several new updates recently announced by Google. The most interesting of these new features is Smart Fill which will launch &hellip; <a href=\"https:\/\/icrowdnewswire.com\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\">Continue reading <span>Google Sheets update will soon compose those pesky formulae for you<\/span><\/a> <a href=\"https:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\" class=\"more-link\">Continue Reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,22,54],"tags":[],"class_list":["post-36415","post","type-post","status-publish","format-standard","hentry","category-english","category-united-states","category-wire"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Sheets update will soon compose those pesky formulae for you - Business<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Sheets update will soon compose those pesky formulae for you - Business\" \/>\n<meta property=\"og:description\" content=\"Smart Fill will be able to intelligently autocomplete data in Sheets later this year (Image credit: Pexels) Building spreadsheets and analyzing the data they contain is about to get a bit easier in&nbsp;Google Sheets&nbsp;thanks to several new updates recently announced by Google. The most interesting of these new features is Smart Fill which will launch &hellip; Continue reading Google Sheets update will soon compose those pesky formulae for you Continue Reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\" \/>\n<meta property=\"og:site_name\" content=\"Business\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-02T13:10:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\" \/>\n<meta name=\"author\" content=\"Aneesa\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aneesa\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\",\"url\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\",\"name\":\"Google Sheets update will soon compose those pesky formulae for you - Business\",\"isPartOf\":{\"@id\":\"https:\/\/ipsnews.net\/business\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\",\"datePublished\":\"2020-07-02T13:10:00+00:00\",\"author\":{\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/cee3758d3201f95199de3522858ca7e2\"},\"breadcrumb\":{\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage\",\"url\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\",\"contentUrl\":\"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ipsnews.net\/business\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Sheets update will soon compose those pesky formulae for you\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ipsnews.net\/business\/#website\",\"url\":\"https:\/\/ipsnews.net\/business\/\",\"name\":\"Business\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ipsnews.net\/business\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/cee3758d3201f95199de3522858ca7e2\",\"name\":\"Aneesa\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ipsnews.net\/business\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5635ace541744f4e232d93d2fafa63d478ed1fd5c863cbc1484fc2148961368f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5635ace541744f4e232d93d2fafa63d478ed1fd5c863cbc1484fc2148961368f?s=96&d=mm&r=g\",\"caption\":\"Aneesa\"},\"sameAs\":[\"https:\/\/icrowdnewswire.com\/fc\"],\"url\":\"https:\/\/ipsnews.net\/business\/author\/aneesa\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Sheets update will soon compose those pesky formulae for you - Business","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/","og_locale":"en_US","og_type":"article","og_title":"Google Sheets update will soon compose those pesky formulae for you - Business","og_description":"Smart Fill will be able to intelligently autocomplete data in Sheets later this year (Image credit: Pexels) Building spreadsheets and analyzing the data they contain is about to get a bit easier in&nbsp;Google Sheets&nbsp;thanks to several new updates recently announced by Google. The most interesting of these new features is Smart Fill which will launch &hellip; Continue reading Google Sheets update will soon compose those pesky formulae for you Continue Reading &rarr;","og_url":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/","og_site_name":"Business","article_published_time":"2020-07-02T13:10:00+00:00","og_image":[{"url":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png","type":"","width":"","height":""}],"author":"Aneesa","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Aneesa","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/","url":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/","name":"Google Sheets update will soon compose those pesky formulae for you - Business","isPartOf":{"@id":"https:\/\/ipsnews.net\/business\/#website"},"primaryImageOfPage":{"@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage"},"image":{"@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage"},"thumbnailUrl":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png","datePublished":"2020-07-02T13:10:00+00:00","author":{"@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/cee3758d3201f95199de3522858ca7e2"},"breadcrumb":{"@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#primaryimage","url":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png","contentUrl":"https:\/\/icrowdnewswire.com\/wp-content\/uploads\/2020\/06\/3998-ICN.png"},{"@type":"BreadcrumbList","@id":"http:\/\/ipsnews.net\/business\/2020\/07\/02\/google-sheets-update-will-soon-compose-those-pesky-formulae-for-you\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ipsnews.net\/business\/"},{"@type":"ListItem","position":2,"name":"Google Sheets update will soon compose those pesky formulae for you"}]},{"@type":"WebSite","@id":"https:\/\/ipsnews.net\/business\/#website","url":"https:\/\/ipsnews.net\/business\/","name":"Business","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ipsnews.net\/business\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/cee3758d3201f95199de3522858ca7e2","name":"Aneesa","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ipsnews.net\/business\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5635ace541744f4e232d93d2fafa63d478ed1fd5c863cbc1484fc2148961368f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5635ace541744f4e232d93d2fafa63d478ed1fd5c863cbc1484fc2148961368f?s=96&d=mm&r=g","caption":"Aneesa"},"sameAs":["https:\/\/icrowdnewswire.com\/fc"],"url":"https:\/\/ipsnews.net\/business\/author\/aneesa\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/36415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/comments?post=36415"}],"version-history":[{"count":1,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/36415\/revisions"}],"predecessor-version":[{"id":36416,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/posts\/36415\/revisions\/36416"}],"wp:attachment":[{"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/media?parent=36415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/categories?post=36415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ipsnews.net\/business\/wp-json\/wp\/v2\/tags?post=36415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}