In Google Sheets, Gemini can help you write formulas. It can help with simple formulas, like finding the sum or average and more complex formulas.

This is one for the formula writers, as this can be a formula killer. We are talking about whitespace, invisible spaces ruining your formula, sometimes before or after the text. This can happen a lot if data has been imported from somewhere else, and can lead to you having no idea why your formula isn't working.