You need to sign in to do that
Don't have an account?
Mark 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"))
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"))
you can write validation as:
IF(TEXT( Delivery_Time__c) != '', Text( StageName )!='',false)