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
Mark Graham 3Mark Graham 3 

Help with opportunity validation rule please

I have a picklist called "Delivery_Time__c" which has 3 values.

I need to setup validation so that the user can't select the Quoted stage on the opportunity record unless they select the a delivery picklist value option.

How can I write this? my code is wrong.... I have this error: "Error: Incorrect number of parameters for function 'ISPICKVAL()'. Expected 2, received 4"

my wrong code:

AND( ISPICKVAL ( Delivery_Time__c, "Standard lead time", "Expedited delivery", "Multiple deliveries" ) , ISPICKVAL( StageName , "Opportunity - quoted"))
jack wilson 21jack wilson 21
Hi Mark Graham 3,

you can write validation as:


IF(TEXT( Delivery_Time__c) != '', Text( StageName )!='',false)
 
Mark Graham 3Mark Graham 3
Thanks, this didnt do the job though :(