I have time dependent workflow email alerts on a custom object which send outs an email alert to user 60,30,15 days before expiry date.But when a new record is created on a custom object with 16 days before expiry date it still sends out 3 email alerts where it should only send 1 email alert to user.
what could be the reason for 3 emails ? Is there a way we could stop sending out 3 emails and just send 1 email to user.
Evaluate the rule when a record is created, and any time it's edited to subsequently meet criteria.
Rule Criteria :
IF(User <> NULL && Expiry_Alert__c = true,true,false)
User Requirement :
Need 3 alerts for 60,30,15days before expiry date if record created date is more than 60 days. 2 alerts for 30,15 days before expiry date if record created date is more than 30days and less than 60days before expiry date and 1 alert if record created date is more than 15 days and less than 30 days before expiry date.