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
kjunkjun 

Keep StageName from saving if a picklist value is not correct

I'm trying to prevent an opportunity from saving when StageName = Verification but picklist named Client equals No or is blank. The picklist value must equal Yes. 

Validation rule allows opportunity record to save if picklist value = No or if picklist value is blank. Can someone help me with this? thx 
AND(
ISPICKVAL( StageName, 'Verification)'),
ISPICKVAL( Client_Verified__c, 'Yes'))

 
Best Answer chosen by kjun
Andrew GAndrew G
try 
AND(
  ISPICKVAL( StageName, 'Verification'),
  NOT(ISPICKVAL( Client_Verified__c, 'Yes'))
)

This assumes that the Client_Verified__c field is a picklist which only allows Yes, No or <Blank>

Regards
Andrew

All Answers

Andrew GAndrew G
try 
AND(
  ISPICKVAL( StageName, 'Verification'),
  NOT(ISPICKVAL( Client_Verified__c, 'Yes'))
)

This assumes that the Client_Verified__c field is a picklist which only allows Yes, No or <Blank>

Regards
Andrew
This was selected as the best answer
kjunkjun
 I was close but not close enough. Thank you!