You need to sign in to do that
Don't have an account?
Katie Appleby
conditional validation rules on 2 picklists
Hey there,
I’m trying to require that one picklist field is conditionally required when the value in another picklist field is selected. Therefore, the picklist field “Resigned_Reason__c” is required only when the picklist field “Substatus” has a value of “Voluntary | Resigned”
I keep getting different errors. The last one saying Incorrect number of parameters for function 'TEXT()'. Expected 1, received .
Here's my validation rule:
AND (NOT (ISBLANK(TEXT (ts2extams__Substatus__c, "Voluntary | Resigned"))), ISBLANK(TEST(Resigned_Reason__c))
Anything stand out that I need to fix? Thanks!
I’m trying to require that one picklist field is conditionally required when the value in another picklist field is selected. Therefore, the picklist field “Resigned_Reason__c” is required only when the picklist field “Substatus” has a value of “Voluntary | Resigned”
I keep getting different errors. The last one saying Incorrect number of parameters for function 'TEXT()'. Expected 1, received .
Here's my validation rule:
AND (NOT (ISBLANK(TEXT (ts2extams__Substatus__c, "Voluntary | Resigned"))), ISBLANK(TEST(Resigned_Reason__c))
Anything stand out that I need to fix? Thanks!
Try Below Validation Please Mark It As Best Answer If It Helps
Thank You!
All Answers
Try Below Validation Please Mark It As Best Answer If It Helps
Thank You!
Few mistake in your validation, you are using TEST instead of TEXT, and your brackets not closed properly
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh