{"id":23677,"date":"2025-09-22T14:46:16","date_gmt":"2025-09-22T07:46:16","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=23677"},"modified":"2025-09-22T14:46:16","modified_gmt":"2025-09-22T07:46:16","slug":"gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables\/","title":{"rendered":"Gemini in Google Sheets helps you create dynamic and easily referenced tables"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_80 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables\/#Co_gi_thay_doi\" >What\u2019s changing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables\/#Bat_dau\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables\/#Thoi_gian_trien_khai\" >Rollout pace<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-helps-you-create-dynamic-and-easily-referenced-tables\/#Tinh_kha_dung\" >Availability<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Co_gi_thay_doi\"><\/span><b>What\u2019s changing<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Building on the introduction of intelligent suggestions for table conversion, we\u2019re now using Gemini to make tables in Sheets even more useful. Now, when you accept a \u201cConvert to table\u201d suggestion, Gemini will automatically format your data as a table and create a meaningful table name (e.g., Project_Status).<\/p>\n<p>Tables help organize your data, simplifying common tasks like sorting and filtering. They also enable the use of table references, which use the table's meaningful name in place of cell coordinates. For example, a formula like =SUM(E2:E15) becomes the more descriptive =SUM(Office_Expenses[Amount]). These names are not only easier to read and understand, but they are also easier to write, appearing in formula autocomplete suggestions as you type.<\/p>\n<p><span style=\"font-weight: 400;\">Crucially, table references are dynamic. The formula's range automatically expands and contracts as you add or remove rows from your table, ensuring your calculations are always up to date and accurate, without you ever needing to manually edit cell ranges again.<\/span><\/p>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/convert-images-to-video-with-veo-3-in-google-vids\/attachment\/geminitablename\/\" rel=\"attachment wp-att-23653\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23653\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName.gif\" alt=\"\" width=\"2556\" height=\"1594\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName.gif 2556w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName-768x479.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName-1536x958.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName-2048x1277.gif 2048w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/09\/GeminiTableName-18x12.gif 18w\" sizes=\"auto, (max-width: 2556px) 100vw, 2556px\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Bat_dau\"><\/span><b>Getting started<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: <\/span><span style=\"font-weight: 400;\">This feature will be on by default and can be disabled by going to Tools &gt; Suggestion controls &gt; (deselect) Enable table suggestions.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thoi_gian_trien_khai\"><\/span><b>Rollout pace<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) currently underway<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 12, 2025<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Tinh_kha_dung\"><\/span><b>Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Available for Google Workspace:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Business Standard and Plus\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Enterprise Standard and Plus\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Customers with the Gemini Education or Gemini Education Premium add-on\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Google AI Pro and Ultra\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Anyone who previously purchased these add-ons will also receive this feature:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Gemini Business*<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Gemini Enterprise* <\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i X\u00e2y d\u1ef1ng tr\u00ean gi\u1edbi thi\u1ec7u c\u00e1c g\u1ee3i \u00fd th\u00f4ng minh \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng, Google hi\u1ec7n \u0111ang s\u1eed d\u1ee5ng Gemini \u0111\u1ec3 l\u00e0m cho c\u00e1c b\u1ea3ng trong Sheets tr\u1edf n\u00ean h\u1eefu \u00edch h\u01a1n n\u1eefa. Gi\u1edd \u0111\u00e2y, khi&hellip;<\/p>","protected":false},"author":2,"featured_media":23665,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-23677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kienthuc","category-google-workspace","entry","has-media"],"_links":{"self":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/23677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/comments?post=23677"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/23677\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/23665"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=23677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=23677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=23677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}