I'm needing some help finishing my workflow.
I have a list that contains an event date and an initial notification date (30 days after an event). Then there is a task to enter data that needs to send notifications to the user 30,45,60, 70 and 80, and 85 day intervals (the task MUST be completed on or before the 90th day).
The problem is that this notification date can change on or before the initial event /notification date entered.
I have created another column which is a yes/no checkbox column which asks if the event was rescheduled- the default is (no), if it was the user is required to enter a reschedule event date which in turn calculates a rescheduled notification date(quick example below).
|event date||notification date||rescheduled event?||rescheduled event date||rescheduled notification date|
I'm trying to figure out how to have a workflow that will determine whether the event was rescheduled, and adjust the notifications based on the rescheduled notification date.
Hopefully this makes sense. Any help is appreciated.