Tipgemini
Write spreadsheet formulas faster with Gemini in Sheets
Analysts describe the calculation and get a working formula from Gemini in Sheets.
Oct 25, 2026
Tip
Write a formula for column [X] that [calculation] using columns [A, B]. Explain it and show the result for row 2.
How to use it
1. Open the sheet and the Gemini panel 2. Describe the calculation and the columns 3. Ask for the formula and an explanation 4. Test it on a few rows 5. Fill down 6. Save common formulas in a notes tab
Result
About 2 hours saved per week; 40% using Gemini daily. Example: Input: "running 12-month average of revenue". Output: a formula with an explanation.
Tips and gotchas
Human review: Analyst tests formulas. Pitfall: Vendor-reported figures. Best for: Financial analysts (Beginner). Time saved basis: Sourced.
blog.google
https://blog.google/products/google-cloud/gen-ai-business-use-cases/