Google has started rolling out an update to Gemini in Google Sheets that allows the AI to diagnose and fix formula errors in one click, as long as your Workspace admin has Gemini for Workspace in Sheets turned on.
According to Google, the new feature can handle pretty much everything from basic arithmetic to very complex calculations. This ability to debug formula errors comes about two years after Google introduced basic formula generation with Gemini in Sheets.
To create a formula with Gemini in Sheets, you open a spreadsheet on your computer and click Ask Gemini in the top right corner. You can also enter an equals sign in any cell and use a shortcut like Ctrl + Alt + G on Windows and Chrome OS, or Command + Ctrl + G on macOS. Once you open the side panel, you write a natural language prompt using your sheet references. For example, you can ask Gemini to divide goals by games, or to find cell C1 in range D:G.
If for some reason, the formula Gemini generated doesn't work, or maybe you wrote the formula yourself, you can troubleshoot the issue directly inside the grid. When a cell shows an error message, you hover over it and click "Fix". This action opens the side panel where Gemini analyzes the data structure and automatically applies the fixes when they are ready. You can cancel the process at any time by clicking stop in the side panel.
Google has been pushing its Gemini integration in Google Sheets for a while now, steadily moving AI features from side panels directly into user spreadsheets. Last year, the Mountain View giant shipped an =AI() Function in Sheets that allowed users to run translation and text generation directly inside cells instead of using the side panel interface.
Earlier this year, the company announced that Gemini in Sheets had reached near-human expert performance, achieving a 70.48% success rate on the SpreadsheetBench dataset.
0 Comments
Load the comments and join the conversation!
Read the comments, ask the editors questions, show respect and join the conversation.