+ Start a Discussion
Rudy JoggerstRudy Joggerst 

Validation rule to make picklist selection mandatory if value from another picklist was selected.

I need help with a validation rule to make a selection from picklist call_outcome__c mandatory if value "Call" was selected from picklist subject.

This is one of many things I've tried: AND(ISPICKVAL( Subject ,'Call'),ISPICKVAL( call_outcome__c ,''))

Thank you in advance
Best Answer chosen by Rudy Joggerst
Mamadou Diallo 14Mamadou Diallo 14
Hello Rudy,

Please try this
 
AND(
ISPICKVAL(Subject,'Call'),
ISBLANK(TEXT(Call_Outcome__c))
)

Don't forget to select it as best answer if it works.

All Answers

Mamadou Diallo 14Mamadou Diallo 14
Hello Rudy,

Please try this
 
AND(
ISPICKVAL(Subject,'Call'),
ISBLANK(TEXT(Call_Outcome__c))
)

Don't forget to select it as best answer if it works.
This was selected as the best answer
Rudy JoggerstRudy Joggerst
Thank you that put me on the right track.

When I copy/pasted your answer, it gave me the following error: Incorrect parameter type for function 'ISPICKVAL()'. Expected Picklist, received Text

I ended up replacing ISPICKVAL with BEGINS and it's now doing what I want it to do. Any idea why it wouldn't accept ISPICKVAL with Subject (which is a picklist)?