Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #362, your Monday morning espresso, in spreadsheet form!

Last week I finished recording and editing all the video lessons for the new Modern Google Sheets course (woohoo!).

I keep track of progress in a Google Sheet (where else of course!) using Tables and dropdown chips:

I'm using Tables extensively now in my Sheets work. I find the benefits over plain data—such as the dropdown chips, table references, and data validation—are well worth the effort of setting up.

As you can see in the preview image above, we use Tables a lot in the new course too. I'll show you all the best practices and tips for making the most of these powerful new tools.

The course will be available from Monday, 20th October.

Now, on to today's newsletter...

➜ News

I.
​At the end of September, Google announced an increase to the conditional notification limit for Google Sheets from 10 to 20 rules per Sheet.

​Read more here >>​

(Conditional Notifications are available to all Google Workspace customers.)

Brought to you by: GQueues Get more from the Google tools you already rely on You’ve already invested in the Google ecosystem. Don’t waste hours learning a new “all-in-one” software or double-pay for features you already have. You’ve tried Google Workspace, but it’s not taking your team to their full potential. Get GQueues to connect your team using the Google products they already know. Try it out today

➜ Sheets Tip #362: Easy way to convert measurements

In this tip, we look at a useful function in Google Sheets: the CONVERT function.

It does exactly what it says on the tin, and converts values from one unit of measure to a different unit of measure. And it has a surprisingly large number of available unit conversions.

It's very easy to use. Give it the value to convert, the start unit, and the end unit.

Here are some examples:

Temperature Conversion

Speed Conversion

Distance Conversion

And, for our future spacefaring kids asking how far it is to the next galaxy, here's how to convert a Parsec into miles.

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

Have a great week!

Cheers,
Ben

P.S. This Google Meet feature could help us all​