Hi Reader,
Welcome to the Google Sheets Tips newsletter #279, your Monday morning espresso, in spreadsheet form!
I hope you had fun on Halloween last week!
This year, we dressed up as vampires and baguettes from our local bakery 🧛🥖
A big thank you to this week's sponsors who help keep this newsletter free to read:
I.
Much as I love spreadsheets, they're not always the answer (shocking, I know!). When you have data that frequently changes and is deeply interconnected, it's better to use a more robust data setup, like Google AppSheet. My friend and fellow Google Developer Expert, Pablo Felip just released the first of four introductory articles on AppSheet:
Discovering Google AppSheet in 48 hours
(Also available in Spanish here.)
_______
Google recently announced the Rating Smart Chip, available to all Google Workspace customers and personal accounts. It's rolling out as we speak so you should already have access or get access very soon.
It lets you add ratings to spreadsheet cells to indicate a rating out of five. For example, you might want to rank movies you've watched or digital tools you've used.
Here's what it looks like:
There are two ways to add a star rating:
1) Go to the menu: Insert > Smart chips > Rating
2) Use the @-menu by typing "@rating" into a blank cell:
You can change the star rating by either typing a number between 1 and 5 in that cell or by clicking on the smart chip and selecting the rating you want.
You can also apply the rating to cells that already contain a number between 1 and 5, and the correct rating will be added.
Use the Font Color option in the toolbar to change the color of the stars:
Unfortunately, you can't change the color of the smart chip background, so the grey pill is always there.
So if you really want to hide it, you can change the background color of the cell to match the grey by selecting a custom color and entering this hex code: #e8eaed
One thing you can't do with these rating smart chips is use them in formulas.
You might want to do that if your data expands and you want to automatically add star ratings to new rows.
To do that, you can use a formula to add stars. Start with the simple CHAR formula and upgrade to a named function version if you use it a lot.
⭐⭐⭐⭐⭐
_______
If you enjoyed this newsletter, please forward it to a friend who might enjoy it.
Have a great week!
Cheers,
Ben
P.S. Everyone’s rock bottom is registering for a data analytics course
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Hi Reader, Welcome to the Google Sheets Tips newsletter #318, your Monday morning espresso, in spreadsheet form! I have a fun data tip for you today, involving a secret feature of the QUERY function. Find that below. But first... Today is a special day because my new Sheets Insiders membership program is officially open for enrollment! Sheets Insiders is a membership program designed to help you work more effectively with Google Sheets and Apps Script. As a member of Sheets Insiders, you get...
Hi Reader, Welcome to the Google Sheets Tips newsletter #318, your Monday morning espresso, in spreadsheet form! I have a fun data tip for you today, involving a secret feature of the QUERY function. Find that below. Have a fabulous week! ➜ News I.Two of the newer features in Google Sheets — Conditional Notifications and Google Tables — are now integrated. Conditional notification rules can now apply to Tables and work with Table names. Some common notification rules will be pre-built into...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #317, your Monday morning espresso, in spreadsheet form! I hope your week is off to a fabulous start. My youngest son is sports-mad. From the moment he wakes up until he falls asleep, he's got a bat and ball in his hands or a football at his feet. Currently, he's obsessed with pickleball, the funny, new version of tennis that's sweeping across the US. So I spent much of this weekend just gone whacking a ball around in...