You need to sign in to do that
Don't have an account?
![Heese Heese](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
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