Triggering an email alert when a specific cell changes

michael_ord
edited 12/09/19 in Smartsheet Basics

New Community member using a demo account but on the verge of committing. Despite going through the vids and training material, I can't figure out an alert that I KNOW has a simple solution.

I simply want to create an alert and send an email to someone when a specific cell changes. Specifically, I have a workflow of about 30 rows and a "Done" column.  For 3 or 4 of these rows, checking the Done column needs to trigger an email to the next group that conditions have been met for them to begin their tasks. When I build the Alert, my trigger is "When Rows are Changed"  and condition is "When Done is Checked" which results in the "Alert Someone" . The problem is that this covers the entire worksheet, and I can't figure out how to add a condition to specify the row or cell.

Thanks for any input to help out this rookie. I promise to get better....

 

Answers