Google Sheets now gives conditional notifications, a brand new characteristic 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 longer, 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 embrace getting an alert when someone adjustments the standing or proprietor of a specific process in a undertaking tracker or when a quantity drops beneath a specific amount in a forecast evaluation.
The notification e-mail from Google will embrace details about who made the change. You may as well arrange notifications for others by including their e-mail tackle whereas setting the foundations.
Some individuals began getting access to the characteristic on June 4th, however it might take longer to reach in your Workspace account (Enterprise, Enterprise, or Schooling — free private accounts aren’t included). Google says its 15-day gradual roll will attain customers who’re on the default launch schedule beginning June 18th.