Smartsheet have just announced that they have released (finally!) conditional notifications, allowing a notification email to be automatically distributed based on the condition of a cell.
Previously only conditional formatting could manage this aspect of the registers, but now you can have conditional formatting (say highlight a row red if the due date is in the past and status is open) as well as issue an email. Here is what smartsheet have to say:
“We’ve made our notifications smarter to help you work even better. Now you can be automatically alerted about specific changes made to a sheet by adding conditions to your notifications, so you can hone in on what you need to know to get your work done.
First, rest assured that any notifications you’ve already set up will continue to work. And even with our improved notifications, you can continue to create familiar, simple rules to alert you when anything on a sheet changes, when sharing settings change, or when something in a given column changes.
Since the ability to set more specific notifications greatly expands your options, we added a new menu to help you set them up. The options let you select anything from general changes to things like sharing, to more specific changes to rows, columns or even cells.”