Skip to main content

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

6 respuestas