Skip to main content
Topics#CollaborationDomanda di dominique piccolo-cotter
dominique piccolo-cotter (VaderWolf) ha fatto una domanda in #Collaboration
21 ago 2020, 14:23

Validation Rules with picklists and multi-select picklists in the formula

Can anyone speak to creating a Validation Rule to meet the following criteria? Not familiar with writing out VR's where there is a picklist and a multi-select picklist in the formula. 

 

If Service Request Status Reason = Customer Canceled OR if Service Request Rejection Reason = Canceled, then Cancellation Reason fields are required

 

Below are API's for cancellation reasons and service request

 

Cancellation_Sub_Reason__c    Picklist

 

Cancellation_Reason__c    Picklist

 

    

 

Status_Reason__c    Picklist

 

Service_Request_Reject_Reason__c    Picklist (Multi-Select)

 

Any insight/suggestions are helpful.  Thank you! 
12 risposte
  1. Shubham Gupta (S&P Global)
    21 ago 2020, 15:14

    Sorry, try this one:

    AND(OR(TEXT(Status_Reason__c) = "Customer", 
    INCLUDES(Service_Request_Reject_Reason__c, "Canceled")), 
    OR(ISBLANK(TEXT(Cancellation_Reason__c)), 
    ISBLANK(TEXT(Cancellation_Sub_Reason__c))))

     

     
Scrivi una risposta...
0/9000