profile

Google Sheets Tips

Sheets Tip 349: Out of breath

Published 5 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 and running again this week, as I've got a few partially complete AI + Sheets workflow tutorials in the works that I'm looking forward to sharing.

➜ News

I.
​Apparently this thing called Google I/O happened last week but I missed it 🤪

It's their main developer conference and, of course, many of the announcements were AI-related.

​100 things they announced >>​

Brought to you by: Florbs - File security for Google Drive

Protect your Google Drive files from unauthorized access

Florbs gives organizations full visibility and central control over file access permissions, helping you protect your data.

🕵 See exactly who has access to your organization’s files and folders.
🤖 Prevent Gemini from surfacing sensitive files.
🧹 Revoke or modify access for hundreds of thousands of files in bulk.
🔍 Detect all files shared with “Anyone with the link” and personal accounts (@gmail.com, @hotmail.com).
⚙️ Automate security policies to maintain ongoing protection.
🏷️ Label files according to your organization’s data classification policy to meet compliance standards.
❌ Eliminate the risk of human error in file access management.

➜ Sheets Tip #349: Double Click to access the Datepicker popup

Today's tip is an easy one.

One you can try right away.

Find any cell in Google Sheets that contains a date value (important that it's a date value and not an output from a formula).

Double click it.

Voilà!

The datepicker pops up, which makes it super easy to select different dates.

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. If I was at a concert...​

Google Sheets Tips

by Ben Collins

Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.

Read more from Google Sheets Tips

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...

13 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...

20 days 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...

27 days ago • 2 min read