{"id":987517276,"date":"2024-11-19T17:10:32","date_gmt":"2024-11-19T17:10:32","guid":{"rendered":"https:\/\/workspace.trace.pt\/table-reference-improvements-in-google-sheets\/"},"modified":"2024-11-19T17:10:32","modified_gmt":"2024-11-19T17:10:32","slug":"table-reference-improvements-in-google-sheets","status":"publish","type":"post","link":"https:\/\/workspace.trace.pt\/fr\/table-reference-improvements-in-google-sheets\/","title":{"rendered":"Table reference improvements in Google Sheets"},"content":{"rendered":"<h3>What\u2019s changing<\/h3>\n<div>Since introducing <a href=\"http:\/\/workspaceupdates.googleblog.com\/2024\/05\/tables-in-google-sheets.html\">tables in Google Sheets<\/a>, we\u2019ve made numerous improvements to ensure users are equipped with the tools they need to accelerate spreadsheet building. <a href=\"https:\/\/support.google.com\/docs\/answer\/14239833?hl=en#:~:text=Table%20references%20are%20a%20special,reference%20cells%20in%20the%20table.\">Table references<\/a>, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting data.\u00a0<\/div>\n<div><\/div>\n<div>Today, we\u2019re excited to announce updates to table references that enhance discoverability and usability. Specifically, users will now see:\u00a0<\/div>\n<div>\n<ul>\n<li>Improved table reference availability, which allows users to reference the items below across both single (e.g., <span>=Table2[[#ALL],[Column 1]]<\/span>) and multiple columns (e.g., <span>=Table2[[#ALL],[Column 1]:[Column 2]]<\/span> ):\u00a0<\/li>\n<ul>\n<li>Full table columns, including column headers, data, and footers (#ALL)\u00a0<\/li>\n<li>Table headers (#HEADERS)\u00a0<\/li>\n<li>Table footers (#TOTALS)\u00a0<\/li>\n<li>Table data, excluding headers and footers (#DATA)\u00a0\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEi7tR6KMTEhqeN6XRU-sAA6uXlUbM53qAQgoJR2lQnEqBAYaqKz01Jj4vaYYl2YrZhy4JDmksBJA154Zt5xcnnEgCM_9ZZKs7NtPFzGRsykGzSy7koeNgwGQ-BsM8nM-UE03zpo8TRdlXI9yaL52PibHh3ng84RJuF0L4B-TtY52ykQ2o06_hI3i5uZfZY\/s700\/Improved%20table%20reference%20availability.png\"><img decoding=\"async\" alt=\"Improved table reference availability\" border=\"0\" data-original-height=\"408\" data-original-width=\"700\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEi7tR6KMTEhqeN6XRU-sAA6uXlUbM53qAQgoJR2lQnEqBAYaqKz01Jj4vaYYl2YrZhy4JDmksBJA154Zt5xcnnEgCM_9ZZKs7NtPFzGRsykGzSy7koeNgwGQ-BsM8nM-UE03zpo8TRdlXI9yaL52PibHh3ng84RJuF0L4B-TtY52ykQ2o06_hI3i5uZfZY\/s16000\/Improved%20table%20reference%20availability.png\"><\/a><\/div>\n<\/li>\n<\/ul>\n<\/ul>\n<ul>\n<li>Formula suggestions, which help you identify formulas that could be more robust. For example, if a user types a working formula that overlaps with a table range, a table reference suggestion will show.\u00a0<\/li>\n<\/ul>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgq499RC_Eyv3zDqAYBBDwJVJpXTqoVAnVVBnaimbsBSciqpRAiFSyH4zJFUF7vBDDQJsTrfXngfz2eYn740Z-RRRs7iuLYep72EUG0LlSNaiY-9hcyzzoyUhD7Cmm-1SH8DFCKkMXhpZrZbuFNdfTd3gfwNWZLy_BRg3JBxVGTZ3rHhaNwQPyk_-IQfwQ\/s1600\/Formula%20suggestions.png\"><img decoding=\"async\" alt=\"Formula suggestions\" border=\"0\" data-original-height=\"970\" data-original-width=\"1600\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgq499RC_Eyv3zDqAYBBDwJVJpXTqoVAnVVBnaimbsBSciqpRAiFSyH4zJFUF7vBDDQJsTrfXngfz2eYn740Z-RRRs7iuLYep72EUG0LlSNaiY-9hcyzzoyUhD7Cmm-1SH8DFCKkMXhpZrZbuFNdfTd3gfwNWZLy_BRg3JBxVGTZ3rHhaNwQPyk_-IQfwQ\/s16000\/Formula%20suggestions.png\"><\/a><\/div>\n<ul>\n<li>Formula corrections for table references, which show a formula correction with a proper table reference when a formula is written incorrectly.\u00a0<\/li>\n<\/ul>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEieEOI2gU6jLL-aCoR-9_EmrPRNwxgPKpnswdFWSOe6dMwtPmxBkH65fMj9QU1r-zpB2SQtjAZRta6tIJKlwZ804XI0g04xWjVIM1_CxiZltMgagzHYnfvIKol5h6-uFg2hIsr4mrO2-fntX30ConiskgLo8lhZTppMD0y3c2ZjygIHJ8LQcAuG6Fkuvio\/s1600\/Formula%20corrections.png\"><img decoding=\"async\" alt=\"Formula corrections\" border=\"0\" data-original-height=\"970\" data-original-width=\"1600\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEieEOI2gU6jLL-aCoR-9_EmrPRNwxgPKpnswdFWSOe6dMwtPmxBkH65fMj9QU1r-zpB2SQtjAZRta6tIJKlwZ804XI0g04xWjVIM1_CxiZltMgagzHYnfvIKol5h6-uFg2hIsr4mrO2-fntX30ConiskgLo8lhZTppMD0y3c2ZjygIHJ8LQcAuG6Fkuvio\/s16000\/Formula%20corrections.png\"><\/a><\/div>\n<div><\/div>\n<h3>Getting started\u00a0<\/h3>\n<\/div>\n<div>\n<ul>\n<li><b>Admins:<\/b> There is no admin control for this feature.\u00a0<\/li>\n<li><b>End users:<\/b> Visit the Help Center to learn more about <a href=\"https:\/\/support.google.com\/docs\/answer\/15637642\">using table references in Google Sheets.\u00a0<\/a><\/li>\n<\/ul>\n<h3>Rollout pace\u00a0<\/h3>\n<\/div>\n<div>\n<ul>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Rapid Release domains<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on November 19, 2024\u00a0<\/li>\n<li><a href=\"https:\/\/support.google.com\/a\/answer\/172177\">Scheduled Release domains<\/a>: Gradual rollout (up to 15 days for feature visibility) starting on December 10, 2024\u00a0<\/li>\n<\/ul>\n<h3>Availability<\/h3>\n<\/div>\n<div>\n<ul>\n<li>Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts<\/li>\n<\/ul>\n<h3>Resources\u00a0<\/h3>\n<\/div>\n<div>\n<ul>\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/15637642\">Google Help: Use table references in Google Sheets\u00a0<\/a><\/li>\n<li><a href=\"https:\/\/support.google.com\/docs\/answer\/14239833\">Google Help: Use tables in Google Sheets<\/a><\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>What\u2019s changing Since introducing tables in Google Sheets, we\u2019ve made numerous improvements to ensure users are equipped with the tools they need to accelerate spreadsheet building. Table references, a way to refer to a table or parts of a table in a formula, are just one example of how tables reduce time spent manually formatting [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-987517276","post","type-post","status-publish","format-standard","hentry","category-noticias"],"acf":[],"_links":{"self":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts\/987517276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/comments?post=987517276"}],"version-history":[{"count":0,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/posts\/987517276\/revisions"}],"wp:attachment":[{"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/media?parent=987517276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/categories?post=987517276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/workspace.trace.pt\/fr\/wp-json\/wp\/v2\/tags?post=987517276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}