Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #351, your Monday morning espresso, in spreadsheet form! Thankfully, I'm fully recovered from the pneumonia I had last month. Sadly, we had to cancel our trip to Europe to see my family. But, the silver lining was an unexpected week at home with no agenda. So we stained the back deck, cleared out the garage, and built some raised beds in the garden. My younger self would have spent the week wallowing, annoyed at the...
8 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #350, your Monday morning espresso, in spreadsheet form! I'm happy to report that I'm feeling a lot better now than I did this time last week. Thanks to modern medicine and plenty of rest, I'm well on my way back to normal (whatever that is these days!). Thanks to the many of you who sent well wishes, it was very much appreciated 🙏. ➜ News I.Google are adding a new setting to Google Forms to allow form responders to...
15 days ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #349, your Monday morning espresso, in spreadsheet form! Last week was a total bust. I started going downhill on Sunday. Then, I was sick in bed on Monday and Tuesday. On Wednesday night, my wife took me to ER, where I was diagnosed with pneumonia. It's been a rough few days but I'm feeling better now and recovering. I still have a way to go but at least I'm heading in the right direction. I hope to get all systems up...
21 days ago • 1 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #348, your Monday morning espresso, in spreadsheet form! Every year I support my sister-in-law's fundraiser for Takoma Elementary School by donating a bundle of all my courses. The full retail price is $999 and at the time of sending this email the current bid is $250. It's a great opportunity to grab all my courses for a reduced price and support a good cause. Place your bid here! ➜ News I.Gemini in Google Sheets just...
29 days ago • 2 min read
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #347, your Monday morning espresso, in spreadsheet form! Redwoods are incredible trees. Not only for their vast size, but also how long they've been alive. I was fortunate to bike through the redwoods in 2014 with my brother. Such magnificent trees! But why am I talking about redwoods? Well, I wanted a nice picture for the example in today's newsletter. Originally, I was going to use company logos, but then I thought...
about 1 month ago • 2 min read
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...
about 1 month 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...
about 2 months 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...
about 2 months 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...
2 months ago • 2 min read