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.
Workflows for Alerts
I've been asked to come up with a way for smartsheet to send an automatic reminder to "Assignee" two days before the target date. This is no big deal and actually very simple to set up; however, the second part is "if the date completed field is empty and equal to or greater than the target date".
I attempted to do this using an if, then statement on a new column named "Reminder Date" and use that as the trigger but now I feel like I'm chasing my tail.
It would be a nice enhancement if smartsheet could apply this type of conditional workflow like they already do for conditional formatting... (wink, wink)