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
Mr. WMr. W 

Validation Rule Help NOT(ISPICKVAL)

This is a fun one, but need a little help.  

 

I am making a validation rule based on Close date and Opportunity Stage and I can't see why it's not working.  

 

 

AND ( 
OR ( 
NOT(ISPICKVAL( StageName, "Closed Won")), 
NOT(ISPICKVAL( StageName, "Closed Lost"))), 
CloseDate < TODAY() 
)

 

 

Basically the requirement is that if the close date is in the past, you cannot update the opportunity stage to Closed Won or Close Lost.  Here is what I got.  It doesn’t seem to be working?  Any help?

 

 

 

skodisanaskodisana

Hi,

 

Please try below.

 

AND ( 
OR ( 
ISPICKVAL( StageName, "Closed Won"), 
ISPICKVAL( StageName, "Closed Lost")), 
CloseDate < TODAY() 
)

 

Thanks,

Srikanth. K