Skip to main content
Topics#Data ManagementRoger Lao's Question
Roger Lao (Y. Hata & Co., Ltd.) asked in #Data Management
Sep 15, 2017, 1:39 AM

Validation Rule to make field required if text field has "Yes" in it picklist field is "No"

Trying to make a VR where field RR__c  (text) is required if field Prior_Delivery_Discrepancy__c (formula text) is "Yes" and field Customer_to_Keep_Items__c (picklist) is "No"

 

I know this doesn't work, but I'm going round and round on this and this is the latest itteration.  

 

IF(

 

AND(

 

TEXT(Customer_to_Keep_Items__c) = "No",

 

CONTAINS(Prior_Delivery_Discrepancy__c, 'Yes'), 

 

ISBLANK(RR__c)), True, True, False)
10 answers
  1. Ryan Kasper (IBM)
    Sep 15, 2017, 11:57 AM
    Definitely was too tired to be doing this last night. You don't need the IF statement at all, like Naveen said. 

     

     

    AND(
    Customer_to_Keep_Items__c = "No",
    ISPICKVAL(Prior_Delivery_Discrepancy__c, 'Yes'), 
    ISBLANK(RR__c))

     

    If you want to keep the IF statement, it had too many trues at the end. I'd use the AND only, it's cleaner. 

    IF(
    AND(
    Customer_to_Keep_Items__c = "No",
    ISPICKVAL(Prior_Delivery_Discrepancy__c, 'Yes'), 
    ISBLANK(RR__c)), True, False)

    @Steve - If you use the formula field in the validation, don't you run the risk of missing the change if you ever need to update the formula? You would have to ensure the VR is updated as well. 

Write an answer...
0/9000