You need to sign in to do that
Don't have an account?
NevDev
Multiple Fields Mandatory Based On Picklist Values
Hi guys,
I am trying to create a validation rule that makes multiple fields mandatory based on various picklist values selected in a picklist field. The fields that I would like to make mandatory include multiple field types. I keep getting error messages using the below formula.
AND(
OR(
ISPICKVAL(Picklist_c , "Value 1"),
ISPICKVAL(Picklist_c , "Value 2"),
ISBLANK (Custom_Field_c 1)
ISBLANK (Date_Field_c 1)
ISBLANK (TEXT (Custom_Picklist_c 1)
ISBLANK (Custom_Field_c 2)
ISBLANK (Date_Field_c 2)
ISBLANK (TEXT (Custom_Picklist_c 2)
I am trying to create a validation rule that makes multiple fields mandatory based on various picklist values selected in a picklist field. The fields that I would like to make mandatory include multiple field types. I keep getting error messages using the below formula.
AND(
OR(
ISPICKVAL(Picklist_c , "Value 1"),
ISPICKVAL(Picklist_c , "Value 2"),
ISBLANK (Custom_Field_c 1)
ISBLANK (Date_Field_c 1)
ISBLANK (TEXT (Custom_Picklist_c 1)
ISBLANK (Custom_Field_c 2)
ISBLANK (Date_Field_c 2)
ISBLANK (TEXT (Custom_Picklist_c 2)
Can you try below format
Please mark this as the best answer if this helps
Validation kicks in if a certain value in a picklist field is selected.
OR(
ISPICKVAL( Picklist__c , "A"),
ISPICKVAL( Picklist__c , "B"),
ISPICKVAL( Picklist__c , "C")),
ISBLANK( TEXT(AnotherField__c)))
if it is a text field, you can put Isblank(Anotherfield__c)
AND(
OR(
ISPICKVAL(Picklist_c , "Value 1"),
ISPICKVAL(Picklist_c , "Value 2")
),
ISBLANK(Custom_Field_c 1),
ISBLANK(Date_Field_c 1),
ISBLANK(TEXT (Custom_Picklist_c 1),
ISBLANK(Custom_Field_c 2),
ISBLANK(Date_Field_c 2),
ISBLANK(TEXT (Custom_Picklist_c 2)
)
Max it will work.......!
Thank you.