I have multiple condition check in a process builder and it must update a string based on the criteria
There are 4 Date fields used in the criteria
[Opportunity].Ops_intro_sent_date__c [Opportunity].Audit_Date__c [Opportunity].Tech_Survey_Complete_Date__c ([Opportunity].Interims_Complete_Date__c
Days_to_Schedule_site_visit__c = Ops_intro_sent_date__c - Audit_Date__c
Days_to_Survey_Pack_Complete__c = Tech_Survey_Complete_Date__c - Audit_Date__c
Node 1 : Condition 1 = this is working Fine
[Opportunity].Ops_intro_sent_date__c = Blank
[Opportunity].Audit_Date__c = Not Blank [Opportunity].Tech_Survey_Complete_Date__c = Not Blank ([Opportunity].Interims_Complete_Date__c = Not Blank
Then
Action
Field - Ops SLA = " Empty String "
Node 2 : Condition 2 = Working Fine
[Opportunity].Ops_intro_sent_date__c = Not Blank
[Opportunity].Audit_Date__c = Blank [Opportunity].Tech_Survey_Complete_Date__c = Blank ([Opportunity].Interims_Complete_Date__c = Blank
Then
Action
Field - Ops SLA = " On track to meet SLA "
Node 3 : Condition 3 = Working Fine
Formula :
AND( [Opportunity].RecordType.Id ='0120Y000000ks1jQAA', !ISBLANK([Opportunity].Audit_Date__c), !ISBLANK ([Opportunity].Ops_intro_sent_date__c), ([Opportunity].Days_to_Schedule_site_visit__c <= 25))
Then
Action
Field - Ops SLA = " On track to meet SLA "
Node 4 : Condition 4 = Working Fine
Formula :
AND( [Opportunity].RecordType.Id ='0120Y000000ks1jQAA', !ISBLANK([Opportunity].Audit_Date__c), !ISBLANK ([Opportunity].Ops_intro_sent_date__c), ([Opportunity].Days_to_Schedule_site_visit__c >25))
Action
Field - Ops SLA = " OFF track to meet SLA "
Node 5 : Condition 5 = Working Fine
Formula :
AND( [Opportunity].RecordType.Id ='0120Y000000ks1jQAA', !ISBLANK([Opportunity].Tech_Survey_Complete_Date__c ), !ISBLANK ([Opportunity].Audit_Date__c ), ([Opportunity].Days_to_Survey_Pack_Complete__c <= 7))
Action
Field - Ops SLA = " On track to meet SLA "
Node 6 : Condition 6 = Fails ( it aways get stuck at " On track to meet SLA " )
Formula :
AND( [Opportunity].RecordType.Id ='0120Y000000ks1jQAA', !ISBLANK([Opportunity].Tech_Survey_Complete_Date__c ), !ISBLANK ([Opportunity].Audit_Date__c ), ([Opportunity].Days_to_Survey_Pack_Complete__c >7))
Action
Field - Ops SLA = " OFF track to meet SLA "
Can some help me here please how to dynamically get the Ops SLA field updated based on Difference between the dates
I have also enable to Evaluate next criteria in every node.
Any help here is much appreciated . Thank you
#Salesforce #Formula Field #Process Builder #Sales Cloud #Salesforce Developer
This is the link to the actual issue: