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
EtaussigEtaussig 

VALIDATION RULE

Hi - I am trying to set a validation rule which will not let the sales team enter a close date less than the date when they mark an opportunity to closed/won. 

 

This is what I have:

AND(ISPICKVAL( StageName, 'Closing Agreement (Won)',  CloseDate < today()))

 

This is the error message:

Error: Incorrect number of parameters for function ISPICKVAL(). Expected 2, received 3

 

Any thoughts?

 

Thanks

EtienneCoutantEtienneCoutant

Hi,

 

You need to close the Function ISPICKVAL as follow:

 

 

AND( ISPICKVAL( StageName, 'Closing Agreement (Won)'), CloseDate < today() )

 

 
EtauEtau

Thanks!!  That worked.