Photo by Max Fischer on Pexels

Frustrated by broken formulas in Google Sheets? Google’s Gemini AI is here to help. Integrated directly into Sheets, Gemini can now diagnose formula failures, offering clear explanations and step-by-step instructions to get you back on track. The AI chatbot also proactively suggests alternative formulas and identifies the correct function for various data manipulation tasks, like counting items meeting specific criteria. While Gemini excels at formula generation and debugging, it’s not a perfect solution. It might require some manual tweaking of generated formulas, and it can’t directly calculate driving distances. However, it can provide custom scripts or the Haversine formula for calculating straight-line distances as a workaround.