Sign Up ›
  • Katie Appleby
  • NEWBIE
  • 10 Points
  • Member since 2017
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
SOLVED
4 replies

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!
 
SOLVED
4 replies

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!