You need to sign in to do that
Don't have an account?
Heese
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.
For instance. If a stage named NotSigned is selected the Amount field must be empty.
Thanks in advance.
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