0

I'm trying to have a text field required when a value is selected in Multi-picklist field

IF(
    AND(TEXT(Environment_Access__c ) = "DevQA", 
        ISBLANK( Business_Justification__c )), 
    True,
    False
)

2 Answers 2

1

First of all, you can always replace IF(condition, true, false) with just condition.

Second, you need to use INCLUDES rather than TEXT.

AND(
    INCLUDES(Multi_Picklist__c, "SingleOption"),
    ISBLANK(Other_Field__c)
)
2
  • That worked i appreciate it
    – vanessa
    Jan 30, 2019 at 16:36
  • @vanessa If this answer addressed your problem, please consider accepting it by clicking on the check mark/tick to the left of the answer, turning it green. This marks the question as resolved to your satisfaction, and awards reputation both to you and the person who answered. If you have >= 15 reputation points, you may also upvote the answer if you wish. There is no obligation to do either.
    – Adrian Larson
    Jan 30, 2019 at 16:47
0

For checking a value in multi select picklist, you will have to use INCLUDES

Your validation rule should be like this

IF(AND(INCLUDES(Environment_Access__c, 'DevQA'), ISBLANK(Business_Justification__c)), true, false)  

Or

AND(INCLUDES(Environment_Access__c, 'DevQA'), ISBLANK(Business_Justification__c))

You can check this link for further help.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.