Nine months after Google infused Gemini AI into Google Sheets, the AI system graduated from text and charts to taking on formulas. (Even those plopped into messy wedding planning spreadsheets, I found.)

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 o

See Full Page