"Gemini's chatbot appears on the right-hand side of Sheets. Now, when you ask how to manipulate data, Gemini will respond with suggested formulas and step-by-step instructions about how to make the formulas work - and why the formulas fail when they do. Errors will be followed up with a guide for how to correct the issue, Google says. If multiple formulas can do the same thing, Gemini will explain the options to the user."
"Formulas, for me, often involve the pesky problem of figuring out which function I need to make it work with my data. (Is it COUNTIF or COUNTIFS, or maybe the wild card of COUNTUNIQUE?) So, I tried Gemini's formula capability out for my wedding guest spreadsheet, a massive jumble of names, categories, email addresses, and checkboxes that my partner and I used to attempt to keep"
Gemini's chatbot in Google Sheets appears on the right side and provides suggested formulas with step-by-step instructions for manipulating data. The system explains why formulas fail and supplies guidance to correct errors. When multiple formulas can accomplish the same task, Gemini outlines the different options and trade-offs. The capability moves Gemini beyond generating text and charts into active formula construction and debugging. The tool supports troubleshooting and is designed to help users choose appropriate functions and handle messy spreadsheets containing names, categories, email addresses, and checkboxes.
Read at The Verge
Unable to calculate read time
Collection
[
|
...
]