You need to sign in to do that
Don't have an account?

Required Field Based on Picklist
Im trying to create a validation rule that makes one Picklist Field required when another Picklist Field is selected.
For example when the Picklist Field(Status) has the value "Unqualifed" theres another picklist field that should be required called "Rating"
Here's my sytax so far, i keep getting errors, any advise?
AND(ISPICKVAL(Status,'Unqualified'),ISNULL(Rating))
For example when the Picklist Field(Status) has the value "Unqualifed" theres another picklist field that should be required called "Rating"
Here's my sytax so far, i keep getting errors, any advise?
AND(ISPICKVAL(Status,'Unqualified'),ISNULL(Rating))
All Answers
Try changing the single quotes/apostrophes to quotes. ( ' -> " )