I’m the first to admit that the amount of joy Google Sheets brings me is a bit odd, but I use it for everything from tracking my earnings to planning trip budgets with friends. So, I’m excited to see that Google is making it easier to get notified about specific changes to my spreadsheet without me learning to code (something I’ve just never gotten into). The company has announced that Google Sheets is getting conditional notifications, meaning you can set rules in spreadsheets that send emails when certain things happen.
For example, you could set it to send you an email notification when a number drops below or above a certain amount or when a column’s value changes at all. You can also set rules that align more with a project manager tool, like getting a notification when a task’s status or owner changes. This tool only requires edit access, with anyone able to set notifications for themselves or others by entering their email addresses. Don’t worry, you can unsubscribe if someone starts sending you unwanted notifications.
To use conditional notifications, go to tools and then conditional notifications or just right-click in a cell. From there, click add rule (you can name the rule or let Google auto-label it) and then select a custom range or column. You can add additional criteria for the rule, such as exactly what a box should say for you to receive a notification. Then, you can manually input email addresses or select a column containing them. However, Google warns that if you do the latter, the number of cells must match the number included in the rule. So, if you have three cells in the rule, you can only highlight three cells with email addresses. If you get confused, Google gets into all the nitty-gritty of it here.
Google Sheet’s conditional formatting is available to anyone with the following workplaces: Businesses Standard and Plus, Education Plus and Enterprise Starter, Standard, Plus or Essential. It started rolling out for Rapid Release domains on June 4 and will begin showing up for Standard Release domains on June 18. In both cases, conditional formatting might take up to 15 days to appear.
You Might Also Like
ISPs are fighting to raise the price of low-income broadband
A new government program is trying to encourage Internet service providers (ISPs) to offer lower rates for lower income customers...
Amazon is giving The Boys the prequel treatment
The Boys may be one season away from ending but it’s not done caking your screens with blood and torn...
You can date everything in Date Everything!
https://www.youtube.com/watch?v=dlxxzmOXRf0Have you ever looked at something in your home like a dining room table or an adjustable height desk and...
The Bioshock movie is still happening but with a reduced budget
We haven't had an update on Netflix’s Bioshock movie in a couple of years, leading some to wonder if it...