profile

Google Sheets Tips

Sheets Tip 349: Out of breath

Published 3 months 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, After a few weeks break for the summer 🏖️, we're back with the Google Sheets Tips newsletter #355, your Monday morning espresso, in spreadsheet form! What's new? AI continues to dominate the tech headlines, with new features crammed into every corner of the internet, whether they’re needed or not. But beyond the hype, the tools are improving, and that includes in the spreadsheet domain. These days, when I need to create a complex formula, I often start with a...

2 days ago • 3 min read

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #354, your Monday morning espresso, in spreadsheet form! In last week's newsletter we compared wide and tall data, and what the pros and cons of each data "shape" were. Today, I want to show you how to move from one format to the other. How to transform tall data into wide data and vice versa. Going in one direction is easy. Going back, in the other direction, is less so. Find out which way round below! ➜ News I. It's...

about 2 months ago • 2 min read

Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #353, your Monday morning espresso, in spreadsheet form! Today we're looking at the shape of data. It's foundational concept that underpins pivot tables and charts in Google Sheets. Once you understand the difference between wide data (for charts) and tall data (for pivot tables), you'll be off to the races! This week is all about the pros and cons of each data shape. Next week, I'll show you how to use formulas and...

about 2 months ago • 2 min read