+ Start a Discussion
HeeseHeese 

Data Validation Rule Need Help

I'm having trouble creating a Data Validation Rule.  I need a rule that basically says if a certain field is selected another field must have no value. 

For instance.  If a stage named NotSigned is selected the Amount field must be empty. 

Thanks in advance.


CJagannathCJagannath

You can write validation rule as followed (considering your example)

 

AND(ISPICKVAL( StageName, "NotSigned"),  Amount  = 0 )  [Considering stage is picklist and amount is currency field]

 

Thanks and regards,

Jagannath