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.
Trending Products
![Cooler Master MasterBox Q300L Micro-ATX Tower with Magnetic Design Dust Filter, Transparent Acrylic Side Panel…](https://m.media-amazon.com/images/I/51WfytAtGCL._SS300_.jpg)
Cooler Master MasterBox Q300L Micro-ATX Tower with Magnetic Design Dust Filter, Transparent Acrylic Side Panel…
![ASUS TUF Gaming GT301 ZAKU II Edition ATX mid-Tower Compact case with Tempered Glass Side Panel, Honeycomb Front Panel…](https://m.media-amazon.com/images/I/41JUuW8Yc5S._SS300_.jpg)
ASUS TUF Gaming GT301 ZAKU II Edition ATX mid-Tower Compact case with Tempered Glass Side Panel, Honeycomb Front Panel…
![ASUS TUF Gaming GT501 Mid-Tower Computer Case for up to EATX Motherboards with USB 3.0 Front Panel Cases GT501/GRY/WITH…](https://m.media-amazon.com/images/I/41j9qzlOi2L._SS300_.jpg)
ASUS TUF Gaming GT501 Mid-Tower Computer Case for up to EATX Motherboards with USB 3.0 Front Panel Cases GT501/GRY/WITH…
![be quiet! Pure Base 500DX Black, Mid Tower ATX case, ARGB, 3 pre-installed Pure Wings 2, BGW37, tempered glass window](https://m.media-amazon.com/images/I/41xW6xrbicL._SS300_.jpg)
be quiet! Pure Base 500DX Black, Mid Tower ATX case, ARGB, 3 pre-installed Pure Wings 2, BGW37, tempered glass window
![ASUS ROG Strix Helios GX601 White Edition RGB Mid-Tower Computer Case for ATX/EATX Motherboards with tempered glass…](https://m.media-amazon.com/images/I/41T-2v3IuML._SS300_.jpg)
ASUS ROG Strix Helios GX601 White Edition RGB Mid-Tower Computer Case for ATX/EATX Motherboards with tempered glass…
![Bgears b-Voguish Gaming PC with Tempered Glass ATX Mid Tower, USB3.0, Support E-ATX, ATX, mATX, ITX. (Note: Fan NOT…](https://m.media-amazon.com/images/I/41p2u3NJN6L._SS300_.jpg)