Triggering an Alert When Data in a Cell Changes
Is there a way to trigger an automation in Smartsheet when data in a cell has been changed from one thing to another after rows are added to a sheet? I keep trying to set up an automation to trigger a reminder (see below) but there doesn't seem to be a condition that matches what I need.
I need SS to send me an email when one of these cells is changed from one person to another...
But the condition doesn't have "is changed" option or one that best fits.
Any ideas on how to fix this?
Help Article Resources
Check out the Formula Handbook template!