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…

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…

What will you let drop today?

Photo by Austin Chan on Unsplash When you work in a startup, you are guaranteed to make a decision that will disappoint someone today. Every day is a series of stack-ranked decisions. You decide (in near real time) whether Item A is more important than Item B, and make the best decision you can at the time. Many…

Thoughts on the Bus Problem

(photo by https://unsplash.com/photos/HOtPD7Z_74s) What’s the most important thing you do at work? Most of us, when asked “how do you create job security”, default to explaining a way of interacting with others that only we can do. If you have unique skills, of course you would want to create a solution where you can solve the…