Brought to you by: Hi Reader, Happy Monday! Welcome to the Google Sheets Tips newsletter #346, your Monday morning espresso, in spreadsheet form. This week's tip comes from a reader who emailed in with a question about Tables in Google Sheets. The answer was yet another benefit to using Tables that I hadn't previously noticed. Check it out below, after this week's news and sponsor message. ➜ News I.Staying with Tables... For developers, Tables are now part of the Google Sheets API...
14 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #345, your Monday morning espresso, in spreadsheet form! A couple of weeks ago I was looking over a Google Sheet with my wife (we help each other with business problems). My wife was extracting town names from a list of addresses and used the Smart Fill feature to automate it. She extracted the first two examples and then Smart Fill did the rest. "Woah, hang on a sec", I said "show me that again." I didn't realize that...
21 days ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #344, your Monday Tuesday* morning espresso, in spreadsheet form! * coming to your inbox on a Tuesday because many folks have a long weekend for Easter. In today's reader-inspired example, we're going to look at a common, but tricky, conditional formatting example: How to highlight values in one range based on activity in a different range? Today we'll look at how to create a conditional formatting rule to highlight...
27 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #343, your Monday morning espresso, in spreadsheet form. Thanks for all the well wishes I received to last week's email! I'm two weeks into the recovery from sinus surgery and things are slowly but surely returning to (a new) normal. I'm taking daily walks around my neighborhood, going slightly further each day. For the first couple of days I needed my wife as a support to hold on to, as I shuffled up and down the...
about 1 month ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #342, your Monday morning espresso, in spreadsheet form! Whew, it's been quite the week in my household. Last week I had sinus surgery to alleviate some long-standing sinus issues I've had. It was a nearly 6-hour surgery so I was completely out-of-it for a day or two afterwards. When I came round they asked if I wanted a drink. I said "some water" but I couldn't speak clearly because of the bandages etc. The nurse...
about 1 month ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #341, your Monday morning espresso, in spreadsheet form! Hope you're out enjoying the beautiful Spring weather 🌱🌼 if you're in the Northern Hemisphere. And Fall if you're down south! ➜ News I.In case you missed it earlier in the month, I've now put the replay from the live Lambda Functions website on YouTube. Watch "Unlocking the Secrets of Lambda Functions" and grab the template for free here: II.My friend, and fellow...
about 2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #340, your Monday morning espresso, in spreadsheet form! I was reminded this week of the power of consistency. In January, I set a goal in Strava to ride my bike 3 times a week. Nothing crazy, but it's what I can realistically fit in with current work and family commitments. Aside from a few weeks of sickness and snow in January, I've done a pretty good job at sticking to it. And yesterday, I could notice a difference....
about 2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #339, your Monday morning espresso, in spreadsheet form! I have a favor to ask. If you enjoy this newsletter, or my courses, videos or membership, will you help me improve them? It's been a while since I've run a full audience survey, and I'd love to get some fresh insight into any challenges you have using Sheets, how you use AI, how I can help, etc. Can you spare a few minutes to fill out my 2025 audience survey?...
2 months ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #338, your Monday morning espresso, in spreadsheet form! After a last bite from winter last week, it looks like spring is finally here where I live on the east coast of the US. The daffodils are growing, the box turtles are out sunning themselves on logs by the river, and temperatures are forecast in the 70s (in the 20s celcius). Wherever you are, I hope you're enjoying the changing of the seasons. ➜ News I.Google...
2 months ago • 2 min read