function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
GoJoyGoJoy 

Validation rule help is needed

I need help creating a validation rule on a picklist fields.
When Opportunity Stage is Best Case, Pipeline, and Commit, when Performance picklist is NOT none, Result picklist field is required.

(
ISPICKVAL(StageName,'Best Case') ||
ISPICKVAL(StageName,'Pipeline') ||
ISPICKVAL(StageName,'Commit')
)
&&
ISPICKVAL( Performance__c,<>"None")
&&
ISPICKVAL( Result__c,"")
Best Answer chosen by GoJoy
Amit Chaudhary 8Amit Chaudhary 8
Please try below validation rule let us know if this will help you
AND(
	OR(
		ISPICKVAL(StageName,'Best Case'), 
		ISPICKVAL(StageName,'Pipeline') ,
		ISPICKVAL(StageName,'Commit')
	),
	
	NOT(ISPICKVAL( Performance__c,"None")),
	ISPICKVAL( Result__c,"")
)

 

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please try below validation rule let us know if this will help you
AND(
	OR(
		ISPICKVAL(StageName,'Best Case'), 
		ISPICKVAL(StageName,'Pipeline') ,
		ISPICKVAL(StageName,'Commit')
	),
	
	NOT(ISPICKVAL( Performance__c,"None")),
	ISPICKVAL( Result__c,"")
)

 
This was selected as the best answer
GoJoyGoJoy
Thank you!  It worked.