Alerts and Notifications

edited 12/09/19 in Smartsheet Basics

Hi everyone! 

New to Smartsheet and trying to figure out the automation aspect - which is what really sold us on the software.  So, I have a question - is it possible to send out notifications/alerts based on specific changes within a row?  For example I have two tasks - Demo1 and Demo2.  I need a notification to be sent out when both of these tasks are complete.  I feel like I'm missing something.  It looks to me like I can only setup alerts/notifications at a sheet level.

Thanks a bunch!  You'll be hearing from me a lot - I'm sure!!