If you spend any time in Google Sheets, you know that building complex financial models or debugging a broken formula can sometimes be a frustrating, time-consuming process. While Google has already supercharged Sheets with AI to make building those complex models easier, they are launching more goodies.
Google is introducing two updates to Gemini in Google Sheets this month which are designed to break down language barriers and eliminate formula error headaches. Even if you don’t need the new multilingual features, you definitely will be using the one-click formula troubleshooting.
Say Goodbye to #REF! Frustration: One-Click Formula Troubleshooting
We’ve all been there. You write a formula, hit enter, and are met with a dreaded error message. Traditionally, this means spending the next 20 minutes parsing through cells or searching for a fix.
With the new formula troubleshooting capability, Gemini in Sheets can diagnose and fix formula errors in a single click. When you encounter a formula error, Gemini will analyze your surrounding data structure, provide an easy-to-understand explanation of what went wrong, and offer a corrected version of the formula that you can apply instantly.
This feature supports any formula from basic arithmetic to highly intricate calculations. By removing the barrier to writing complex formulas right where you work, both novice users and seasoned data analysts can save time and maintain their focus.
Breaking Down Language Barriers: Expanded Language Support
Earlier this year, Google introduced the ability to build and edit entire spreadsheets using natural language prompts with Gemini. Now, this powerful capability is going global.
Google is officially expanding prompt support for Gemini in Sheets to 28 additional languages. This means users can now issue prompts to Gemini in their native language to update budgets, conduct data analysis, and execute complex tasks using pivot tables, charts, and formulas.
Some of the newly supported languages include:
- Spanish
- Portuguese
- Japanese
- Korean
- French
- German
- Italian
- Chinese (Simplified)
- Arabic
- Hindi, Dutch, Vietnamese, and many more!
Global teams can now manage data and extract cross-document insights natively without confronting language barriers. Whether you're collaborating with an office in Tokyo or reviewing financial models from a team in Berlin, Gemini can bridge the gap and keep your momentum going.
Both features are available now for customers with Business Standard/Plus, Enterprise Standard/Plus, Google AI Pro/Ultra (Consumers), and Education Add-ons (Google AI Pro for Education).
Are you ready to switch to Google Workspace now that Google Sheets is so easy to use and Gemini AI-enables your entire business? Contact UpCurve Cloud today. We will migrate everything without a hitch, train your staff, and be there if you ever need support from a premier Google Partner.
Contact Us to Learn More about Transforming Your Business