Anyone have any ideas as to why this validation might not work? Its basically trying to say if opportunity type is "New Client", probability is greater than 74% and contract length is blank throw and error to make users populate the contract length.
AND((ISPICKVAL(Type, "New Client")),(Probability > 74),
(ISBLANK(Contract_Length__c)))
Thanks,
3 answers
Hey Alastair,
The probability is Percentage field ,In your formula it needs to be defined as 0.74,over all your formula will look something like this:-
AND(
ISPICKVAL(Type, "New Client"),
Probability >0.74,
ISBLANK(Contract_Length__c))
Regards,
Subbu.
