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
Mike A SmithMike A Smith 

picklist validation rule

I have 2 picklists ('ED/VP Invoicing Approver' and 'Invoice Justification')  that I need a validation rule to require the specific value 'Special Approval' in Invoice Justification IF and approver name is selected in ED/VP Invoicing Approver.

In other words;

When ED/VP Invoicing Approver is entered, Invoice Justification = Special Approval is required

I'm not sure how to require the specific value in the second picklist ... suggestions?
Best Answer chosen by Mike A Smith
PriyaPriya (Salesforce Developers) 

Hi Mike,

This worked for me 

User-added imageNOT(ISBLANK(Text(ED_VP_Invoicing_Approver__c ))) &&
NOT(ISPICKVAL( Invoice_Justification__c , "Special Approval"))

Please mark as Best Answer so that it can help others in the future.

Regards

All Answers

PriyaPriya (Salesforce Developers) 

Hi Mike,

This worked for me 

User-added imageNOT(ISBLANK(Text(ED_VP_Invoicing_Approver__c ))) &&
NOT(ISPICKVAL( Invoice_Justification__c , "Special Approval"))

Please mark as Best Answer so that it can help others in the future.

Regards

This was selected as the best answer
Mike A SmithMike A Smith
That worked, thanks!