Hi guys, I need to do a workflow that sends out emails to remind people how many days till the due date. I calculated the difference between the Due Date and the Current Date column and got the amount of days left in my DaysLeft column.
These are the 3 conditons:
1. If 7 days left on the DaysLeft, one email will be sent.
2. If 3 to 0 days left, It will send a reminder everyday
3. If negative value on the DaysLeft, it will send a reminder everyday.
This is my workflow
I already did the workflow which updates the Current Date column everyday. Thus the DaysLeft column will be updated as well. Now I just need the workflow for the email. I tried using the Run If function but I dunno how to input the values in the configuration. I have the pic for the If Configuration for the 1st condition. I also don't know how to make it so that the value will be in a range like 3 to 0 for the 2nd condition . As well as Infinite range 0< for the 3rd condition.
Finally I need to put the amount of days left in the email message as well, how do I put DaysLeft Column as a dynamic text? Please take a look and tell me is it correct thank you