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
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)?