Google Sheets’ new tool lets you set specific rules for notifications.

I’m the first to admit the amount of joy Google Sheets It sounds a little weird to me, but I use it for everything from tracking my earnings to planning travel budgets with friends. So I’m happy to see that Google makes it easy to get notified of specific changes to my spreadsheet without learning how to code (something I’ve never gotten into). The company released information about this Google Sheets receives conditional notificationsthat is, you can set rules on schedules that send emails when certain things happen.

For example, you can 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 in general. You can also set rules that are more compatible with the project manager tool, such as receiving notifications when a task status or owner changes. This tool only requires edit access, anyone can set up notifications for themselves or others by entering their email address. Don’t worry, if someone starts sending you unwanted notifications, you can unsubscribe.

To use conditional notifications, go to tools and then conditional notifications or right-click the cell. From there, click Add rule (you can name the rule or let Google tag it automatically), and then select a custom range or column. You can add additional criteria to the rule, such as what exactly the box needs to say to receive a notification. You can then manually enter email addresses or select the column that contains them. However, Google warns that if you do the latter, the number of cells must match the number entered in the rule. So if you have three cells in a row, you can highlight only the three cells with email addresses. If you’re confused, Google goes into all the ins and outs of it here.

Conventional formatting of Google Sheets is available to anyone with Businesses Standard and Plus, Education Plus and Enterprise Starter, Standard, Plus or Essential. It started rolling out to Rapid Release domains on June 4th and will start appearing on June 18th for Standard Release domains. In both cases, conditional formatting may take up to 15 days to appear.

Source link

Leave a Reply

Your email address will not be published. Required fields are marked *