I had a requirement where i need to send an email notification 100 days before the contract end date based on the condition.So i have created the workflow rule with the condition and time based workflow ,email alert.Which worked fine.
Now once the 100 days email is sent to the opportunity owner,then their are two fields on contract object "SRR" (picklist field - as yes/no) and "renewed" as a formula field.Now the opportunity owner will update the field "SRR" value and "renewed" .
1)If the owners updates the field "SRR" value as "Yes" then an email needs to send to the customer (customer email is from contact email .how can i get that to send an email )for 45 /30 /15 days before the contract end date.
2)If the owners updates the field "SRR" value as "No" then stop sending email needs to the customer .
3)If the owners does not updates the field "SRR" value within 90 days before the contract end date,then an email needs to be sent to the owner and superior.
I have created a WFR for 90 days notification with conditions as .
(Contract: Contract End DateNOT EQUAL TOnull) AND (Contract: Renewed EQUALSTrue) AND (Contract: SRR EQUALSYes)
Now how can i update the formula field as "checked ".
While sending an email alert ,im not getting the contact email(formula field on contract object) to select .
How can i get this filter in WFR .Any help or example very much appreciated.