A simple one on the surface of it, but I couldn’t find a quick answer. Hopefully this saves you some time Let’s say you have a Google Sheet where you have a bunch of rows, and you want to count the total number of rows in a range dynamically. In other words, when you add … Read more
In this post we will look at how to use Google Sheets conditional formatting to change the colour of cells based on the given date. Here’s an example of what we will achieve: The conditional formatting rules I have applied here are: And it’s actually much easier than you might think (and easier than I … Read more
I made a previous post about how you can use a couple of actions built into Google Sheets to help you delete empty rows for a given column. In that post I got a comment asking if it’s possible to automate the deletion in some way. It is. And to do that, one way would … Read more
Today I faced an issue where I was copy / pasting rows from a LibreOffice Calc spreadsheet document into a new Google Sheets spreadsheet. The problem I faced was when I did this, I retained all the empty rows / gaps in between that I didn’t want. Here’s a basic example of what I started … Read more