You need to sign in to do that
Don't have an account?
Rung41
Picklist validation
Help with validation if one picklist is populated another one needs to be null. Basically the user can only choose a value from Picklist 1 OR Picklist 2. Not both.
I tired the following validation rule but it's not working.
(ISPICKVAL(WidgetA__c '')) =
(ISPICKVAL(WidgetB__c, ''))
I tired the following validation rule but it's not working.
(ISPICKVAL(WidgetA__c '')) =
(ISPICKVAL(WidgetB__c, ''))
NOT(ISBLANK(TEXT(WidgetA__c))) && NOT(ISBLANK(TEXT(WidgetA__c)))
All Answers
NOT(ISBLANK(TEXT(WidgetA__c))) && NOT(ISBLANK(TEXT(WidgetA__c)))
Above formula will work fine. If scenario like user should select one not both. Means you can use this.
OR(NOT(ISBLANK(TEXT(Type__c))) && NOT(ISBLANK(TEXT(TestPicklist__c))) , ISBLANK(TEXT(Type__c)) && ISBLANK(TEXT(TestPicklist__c)))