function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
NK ShaNK Sha 

I have an 2 pick list values Subtype As Campain and the Another Pick List As LB Campain when we select the pick List in the Sub Type As Campain the LB Campain and LB Campain Group are mandatory by creating the validaton rules

I have an 2 pick list values Subtype As Campain and the Another Pick List As LB Campain when we select the pick List in the Sub Type As Campain the LB Campain and LB Campain Group are mandatory  by creating the validaton rules
Best Answer chosen by NK Sha
Ajay K DubediAjay K Dubedi
Hi Naveen,

There is some statements missing in your requirements, but still, you can try the below formula: 

AND(
ISPICKVAL(Subtype__c, "Campain"),
ISBLANK (LB_Campain__c),
ISBLANK(LB_Campain_Group__c)
)


The above formula will make other two picklist values as mandatory. Let me know If you need more guidance on this.

Hope it helps.

Thank you,
Ajay Dubedi.

All Answers

Akshay_DhimanAkshay_Dhiman
Hi Naveen Karumuri,

AND(NOT(ISBLANK(PickList1__c)), ISBLANK(TEXT(Picklist2__c)))


if Picklist1 is a specific value then use this formula.

AND(
TEXT(LeadSource) = "Sales Referral",
ISBLANK(TEXT(Sales_Referral_By__c))
)



if you found this answer helpful then please mark it as best answer so it can help others.   
  
  Thanks 
  Akshay
Ajay K DubediAjay K Dubedi
Hi Naveen,

There is some statements missing in your requirements, but still, you can try the below formula: 

AND(
ISPICKVAL(Subtype__c, "Campain"),
ISBLANK (LB_Campain__c),
ISBLANK(LB_Campain_Group__c)
)


The above formula will make other two picklist values as mandatory. Let me know If you need more guidance on this.

Hope it helps.

Thank you,
Ajay Dubedi.
This was selected as the best answer