A few things, done easier

Have you recently read about a product and thought: “it does too much?” Yet it’s also easy to disqualify a product or service as too narrow and “not for me”. How do you split the gap and build for the people who really want (and need) what you are selling without simply disappearing into the…

Applying Regular Expressions to Sort Items in Google Sheets

Lists are more useful when grouped. When you need to analyze a large list of items, you need to create areas of commonality to enable grouping and sorting that list. A simple example of grouping might be to think about a grocery list, where certain items (bananas, oranges) are fruits and other items (paper plates,…

Spreadsheets are not scary

What was the last document you created? I’m guessing it was either an email, a Word document, or a Google Doc. Perhaps it was a Slack message but since when you use Slack you create several hundred messages a month (or day), so let’s not count that. Why wasn’t it a spreadsheet (Excel or Google…

On blocks and facing the empty page

I wrote and deleted this post several times before continuing to write. It’s not easy to think of yourself as a writer and not have the words to say what’s in your head. It is easy to delete the draft, go back to what you were doing, and go another day without writing. The empty…

Make a Boolean Expression From A List of Rows in Google Sheets

We all use search forms every day. There’s usually an advanced search form of some sort that allows you to enter a boolean expression. You know Boolean expressions as “This OR That” – an inclusive search that increases results – or “This AND That” – an exclusive search that limits results. When you need to…