Google Sheets now gives conditional notifications, a brand new function that lets customers arrange guidelines to obtain an e mail notification when sure spreadsheet cells change in any doc the place they’ve enhancing entry.
Any further, customers can set guidelines in Google Sheets to obtain notifications when sure standards are met, like an up to date column worth or adjustments to a particular vary of cells.
Examples Google gave for conditional notifications embody getting an alert when any individual adjustments the standing or proprietor of a selected process in a mission tracker or when a quantity drops beneath a certain quantity in a forecast evaluation.
The notification e mail from Google will embody details about who made the change. You may as well arrange notifications for others by including their e mail deal with whereas setting the principles.
Some individuals began having access to the function on June 4th, however it might take longer to reach in your Workspace account (Enterprise, Enterprise, or Training — free private accounts are usually not included). Google says its 15-day gradual roll will attain customers who’re on the default launch schedule beginning June 18th.