AnsweredAssumed Answered

How to sent emails with If Condition

Question asked by ieatorange98 on May 30, 2018
Latest reply on Jun 7, 2018 by emha

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

Attachments

Outcomes