{"id":23959,"date":"2025-10-21T15:56:58","date_gmt":"2025-10-21T08:56:58","guid":{"rendered":"https:\/\/gcloudvn.com\/?p=23959"},"modified":"2025-10-21T15:56:58","modified_gmt":"2025-10-21T08:56:58","slug":"gemini-in-google-sheets-now-provides-smarter-more-conversational-formula-generation","status":"publish","type":"post","link":"https:\/\/gcloudvn.com\/en\/kienthuc\/gemini-in-google-sheets-now-provides-smarter-more-conversational-formula-generation\/","title":{"rendered":"Gemini in Google Sheets now provides smarter, more conversational formula generation"},"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-now-provides-smarter-more-conversational-formula-generation\/#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-now-provides-smarter-more-conversational-formula-generation\/#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-now-provides-smarter-more-conversational-formula-generation\/#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-now-provides-smarter-more-conversational-formula-generation\/#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>Earlier this year, we made it easier to generate charts and insights using Gemini in Google Sheets. Building on that momentum, we\u2019re excited to announce a significant enhancement to formula generation in Gemini for Sheets. Specifically, we've upgraded Gemini to include detailed natural language formula explanations, provide formula error explanation and self-correction, and to output multiple formula options.<\/p>\n<p><span style=\"font-weight: 400;\">With these updates, Gemini can provide a full, reasoned response, making formula generation smarter and more resilient, and helping users to understand the formulas and calculations happening in their sheets.<\/span><\/p>\n<ol>\n<li><span style=\"font-weight: 400;\"> Detailed natural language formula explanations:<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/collaborate-with-gemini-in-google-drive-now-available-on-mobile\/attachment\/detailed-natural-language-formula-explanations\/\" rel=\"attachment wp-att-23934\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23934\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/DETAILED-NATURAL-LANGUAGE-FORMULA-EXPLANATIONS.gif\" alt=\"\" width=\"2048\" height=\"1119\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/DETAILED-NATURAL-LANGUAGE-FORMULA-EXPLANATIONS.gif 2048w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/DETAILED-NATURAL-LANGUAGE-FORMULA-EXPLANATIONS-768x420.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/DETAILED-NATURAL-LANGUAGE-FORMULA-EXPLANATIONS-1536x839.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/DETAILED-NATURAL-LANGUAGE-FORMULA-EXPLANATIONS-18x10.gif 18w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Complex formulas can now be returned with step-by-step explanations of how they work. This improves user understanding and builds trust, making it easier to learn and adapt formulas for future use. If Gemini doesn\u2019t provide an explanation as part of the response, you can always ask in your next query how the generated formula works.<\/span><\/p>\n<ol start=\"2\">\n<li><span style=\"font-weight: 400;\"> Error explanation and self-correction:<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/collaborate-with-gemini-in-google-drive-now-available-on-mobile\/attachment\/error-explanation-and-correction\/\" rel=\"attachment wp-att-23933\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23933\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/error-explanation-and-correction.gif\" alt=\"\" width=\"1424\" height=\"996\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/error-explanation-and-correction.gif 1424w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/error-explanation-and-correction-768x537.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/error-explanation-and-correction-18x12.gif 18w\" sizes=\"auto, (max-width: 1424px) 100vw, 1424px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">Gemini can now explain why a formula failed (e.g., \"the date in A1 is formatted as text\") and, in a follow-up turn, use the error message to generate a corrected formula that solves the underlying issue.<\/span><\/p>\n<ol start=\"3\">\n<li><span style=\"font-weight: 400;\"> Multiple formula options:<\/span><\/li>\n<\/ol>\n<p><a href=\"https:\/\/gcloudvn.com\/en\/kienthuc\/collaborate-with-gemini-in-google-drive-now-available-on-mobile\/attachment\/multiple-formula-options\/\" rel=\"attachment wp-att-23931\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23931\" src=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/multiple-formula-options.gif\" alt=\"\" width=\"2048\" height=\"1119\" srcset=\"https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/multiple-formula-options.gif 2048w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/multiple-formula-options-768x420.gif 768w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/multiple-formula-options-1536x839.gif 1536w, https:\/\/gcloudvn.com\/wp-content\/uploads\/2025\/10\/multiple-formula-options-18x10.gif 18w\" sizes=\"auto, (max-width: 2048px) 100vw, 2048px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">For more complex tasks or when there are several ways to achieve a result, Gemini can now provide multiple formulas.<\/span><\/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. Admins can turn on the personalization setting for their users in the Admin console.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">End users: You can access Gemini for Sheets in the side panel by clicking on \u201cAsk Gemini\u201d (spark button) in the top right corner of Sheets. Visit the Help Center to learn more about collaborating with Gemini in Sheets.<\/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;\">This update is already available for all Gemini users.<\/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;\">Google AI Pro for Education<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Available to<\/span><\/p>\n<ul>\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* Gemini Enterprise* <\/span><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>C\u00f3 g\u00ec thay \u0111\u1ed5i \u0110\u1ea7u n\u0103m nay, Google \u0111\u00e3 l\u00e0m cho n\u00f3 d\u1ec5 d\u00e0ng h\u01a1n \u0111\u1ec3\u00a0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u00e0 th\u00f4ng tin chi ti\u1ebft b\u1eb1ng Gemini trong Google Sheets.Ti\u1ebfp n\u1ed1i \u0111\u00e0 ph\u00e1t tri\u1ec3n \u0111\u00f3, Google vui m\u1eebng th\u00f4ng b\u00e1o v\u1ec1&hellip;<\/p>","protected":false},"author":2,"featured_media":23930,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1,134],"tags":[],"class_list":["post-23959","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\/23959","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=23959"}],"version-history":[{"count":0,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/posts\/23959\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media\/23930"}],"wp:attachment":[{"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/media?parent=23959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/categories?post=23959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gcloudvn.com\/en\/wp-json\/wp\/v2\/tags?post=23959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}