function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
bheemudu neelibheemudu neeli 

I need to make multiple fields are mandatory Based on One multiselect picklist value by validation rule

Hello,
Is any one can help my issue it is urgent. I need to write validation rule.
I need to make multiple fields are mandatory Based on One multiselect picklist value by validation rule, is it possible?
I tried many ways as below, but doesn't solve my issue.
AND(INCLUDES( Sales_org__c, 'GB01'),
 ISBLANK(Customer_Group_1__c),
 ISBLANK(Channel__c)
)
.................

AND(INCLUDES( Sales_org__c, "GB01"),
     INCLUDES( Customer_Group_1__c, ""),
      INCLUDES( Channel__c, ""))
..................................

IF(INCLUDES(Sales_org__c, 'GB01'),INCLUDES(Sales_org__c, ''),FALSE)
..........................................

IF(ISPICKVAL(Sales_Unit__c, 'Bottles'),Quantity__c,
IF(ISPICKVAL(Sales_Unit__c, 'cases'), Quantity__c * Product__r.Bottles_per_Case__c,
IF(ISPICKVAL(Sales_Unit__c, 'each'),Quantity__c, null) )
.......................................................
NOT(INCLUDES( Sales_org__c, "GB01")&& INCLUDES( Customer_Group_1__c, "")&& INCLUDES( Channel__c, ""))
................................
AND(INCLUDES( Sales_org__c, "GB01"), NOT(AND(INCLUDES( Customer_Group_1__c, ""), INCLUDES( Channel__c, ""))))
 

Thanks in Advance
 
Best Answer chosen by bheemudu neeli
kevin lamkevin lam
I think what you need is something like this:

AND(INCLUDES( Sales_org__c, 'GB01'),
         OR(ISBLANK(Customer_Group_1__c),
                ISBLANK(Channel__c)
              )
       )