It is great that we have left behind the days of "can you leave the spreadsheet so I can edit it?", collaboration has completely changed how we would as a team. However, it can come with the new issue of "who deleted cell c14?", or does it?

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.