Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Alert User in Row if Date has Past Due and not Complete
I would like to send an alert to the person "assinged" to the appropriate row the day after a "Due Date" IF a "Status" column has/doesn't have a value(s).
For example, "Send 'Assigned To' and email reminder 1 day after 'Due Date' IF 'Status' does not equal 'Completed; Canceled.'"
I want to target these communications to only occur when the person has missed a deadline and aviod overcommunicating. I don't want these alerts to turn into emails that occur so frequently that they inevitably get ignored.