Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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