Skip to main content
Topics#Sales And MarketingQuestion de Niccolo Antinucci
Niccolo Antinucci (On) a posé une question dans #Sales And Marketing
8 juil. 2020, 13:03

Process Builder | ISPICKVAL & Formula evaluates true

Hey guys, 

I am working on a process builder which aims at automatically filling a picklist field called ''Overall Outcome'' for an object called ''QA''. 

Overall Outcome has F1, F2, F3, F4 values and, whenever a field is manually filled within a certain record type, Overall Outcome gets filled automatically. Anything wrong in my formula?

When I test, it's not working properly.

 

AND(

 

[Quality_Assurance__c].RecordType.Name = "FRL",

 

NOT(ISPICKVAL([Quality_Assurance__c].Stage__c, "Closed")),

 

OR( 

 

OR(

 

ISPICKVAL([Quality_Assurance__c].Complaint_identified_addressed_evidenced__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Correct_Outcome_Reached__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Redress_Ex_Gratia_paid_appropriately__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Customers_Personal_Circumstance__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Customer_Personal_Vulnerability__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Investigation_Rationale_Clear__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Correspondence_Quality__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Customer_calls_in_line_with_procedure__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Complainant_Updated_on_progress__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_letters_sent_within_SLA__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_resolved_in_15_days__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Flagged_as_PS_complaint__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Notes_left_on_appropriate_systems__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Systems_Updated__c,"F1"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_Files__c,"F1")

 

),

 

OR(

 

ISPICKVAL([Quality_Assurance__c].Complaint_identified_addressed_evidenced__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Correct_Outcome_Reached__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Redress_Ex_Gratia_paid_appropriately__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Customers_Personal_Circumstance__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Customer_Personal_Vulnerability__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Investigation_Rationale_Clear__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Correspondence_Quality__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Customer_calls_in_line_with_procedure__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Complainant_Updated_on_progress__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_letters_sent_within_SLA__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_resolved_in_15_days__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Flagged_as_PS_complaint__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Notes_left_on_appropriate_systems__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Systems_Updated__c,"F2"),

 

ISPICKVAL([Quality_Assurance__c].Complaint_Files__c,"F2")

 

)

 

 

 

)

 

)
12 réponses
  1. Charu Goyal (Crowe)
    8 juil. 2020, 13:20
    Hi Nicolo,

     

    You've written OR 2 times. As shown below, isn't it shloud be one time only.

     

    OR( 

     

    OR(

     

    Regards,

     

    Charu Goyal
Rédiger une réponse...
0/9000