Google Sheets now offers conditional notifications, a new feature that allows users to configure rules to receive an email notification when certain spreadsheet cells change in any document where they have editing access.
Moving forward, users can set rules in Google Sheets to receive notifications when certain criteria are met, such as an updated column value or changes to a specific range of cells.
Examples Google gave for conditional notifications include receiving an alert when someone changes the status or owner of a particular task in a project tracker or when a number drops below a certain amount in a forecast analysis.
The Google notification email will include information about who made the change. You can also set up notifications for other people by adding their email address while setting up rules.
Some people started getting access to the feature on June 4, but it may take longer to reach your Workspace account (Business, Enterprise, or Education; free personal accounts are not included). Google says its 15-day rolling rollout will reach users who are on the default rollout schedule starting June 18.
