I am attempting to create a Workflow Rule that will send an email notification to the Account Owner 110 before the contract end day.
Condition to be given is :
a)"Renewal_Status__c" is equal to pipeline ,next renewal status And b)when the "Next_Quarter_Renewal_Status__c" is not equal to renewed ,renewed lost. c)Contact Role equal to sa/ra/ta.
Here "Renewal_Status__c" and "Next_Quarter_Renewal_Status__c" are picklist field.Contact role is a custom object which has role has picklist field and has a lookup relation with contract . I tried creating the workflow and email alert but its not working.
WorKFlow Criteria given : Workflow Rule Detail
Rule Name @110 Send Email Notification Object Contract Active Checked Evaluation Criteria Evaluate the rule when a record is created, and any time it's edited to subsequently meet criteria Description Send email notification to the Account owner @110 days before the contract end date. Rule Criteria ISPICKVAL(Renewal_Status__c , 'Pushed Forward To Next Quarter')|| ISPICKVAL(Renewal_Status__c, 'In Pipe') && Not(ISPICKVAL(Next_Quarter_Renewal_Status__c , 'Renewed' ) || ISPICKVAL(Next_Quarter_Renewal_Status__c, 'Renewal lost'))
Time-Dependent Workflow Actions : 110 Days Before Contract: Contract End Date
Type :Email Alert
Description :@110 Email Notification to Account Owner
Email Alert :
Email Alert Detail
Description : @110 Email Notification to Account Owner Email Template: @110 Days Notification email Unique Name : X110_Email_Notification_to_Account_Owner Object : Contract From Email Address : Current User's email address Recipients : Contract Owner Additional Emails:-
But the workflow is not getting triggered any help very much appreciated.