+ Start a Discussion
Malisa Gibbons 9Malisa Gibbons 9 

How do I create a validation rule to be mandatory only if the probability on an opportunity is 80% or above?

I have created a new field "Deployment Method" which I want to be mandatory only when the opportuntiy probabiliyt  is 80% or Higher.
How do I write this validation rule?
Best Answer chosen by Malisa Gibbons 9
Steven NsubugaSteven Nsubuga
AND(OR(ISBLANK(TEXT(DeploymentMethod)), ISNULL(TEXT(DeploymentMethod))), Probability >= 0.8)

 

All Answers

Steven NsubugaSteven Nsubuga
AND(OR(ISBLANK(DeploymentMethod), ISNULL(DeploymentMethod)), Probability >= 0.8)

 
Malisa Gibbons 9Malisa Gibbons 9
The field is a picklist so cannot get the formula to work.
Steven NsubugaSteven Nsubuga
AND(OR(ISBLANK(TEXT(DeploymentMethod)), ISNULL(TEXT(DeploymentMethod))), Probability >= 0.8)

 
This was selected as the best answer