+ Start a Discussion
NevDevNevDev 

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)

 
Vasani ParthVasani Parth
Nevin,

Can you try below format
IF(
AND(
TEXT(Field) = "Other", 
LEN(picklist) = 0), True, False)

Please mark this as the best answer if this helps
NevDevNevDev
Hi Vasani,

Validation kicks in if a certain value in a picklist field is selected. 
NevDevNevDev
That doesn't work Vasani
BM 5BM 5
AND(

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)
Ginjupalli AviGinjupalli Avi
First of all try to check two fields isblank and try 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)
)

Max it will work.......!
Thank you.
hick sonhick son
Il robot aspirapolvere offre pulizia potente, controllo delle app e supporto dei comandi vocali Alexa a un prezzo imbattibile. L'aspirazione è una delle faccende domestiche più odiate. Scopri di più sui dettagli dei Miglior Robot Aspirapolvere 2020 qui. https://robotaspirapolvere.me