Workflow - Reminders with Date Trigger
Hi, here is some background and below the question. I am using a smartsheet to enter basic contract information for multiple vendors that service our company. It's important to track their termination notice due date so we can send out the notices on time if we choose not to renew.
As I add the contract info. to the smartsheet (each contract is on its own row), I have been setting up a reminder per row to be sent out based on the Termination Notice Reminder column.
However, I want to create a workflow that would add a reminder for any rows that have a date in the Termination Notice Reminder column which:
a- currently has no reminder is set.
b- as I enter new rows, I want this reminder to be set as well.
Please help!! I don't want to have to do this manually.. and I haven't been able to come up with the right solution/workflow.😊