Validation Rule text field required when multi-picklist value is selected

Question

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
)

Adrian Larson · Accepted Answer · 2019-01-30 14:23:00Z

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)
)

answered Jan 30, 2019 at 14:23

Adrian Larson♦

151k38 gold badges246 silver badges428 bronze badges

That worked i appreciate it
– vanessa
Commented 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 ♦
Commented Jan 30, 2019 at 16:47

Add a comment |

Vijay Ganji · Accepted Answer · 2019-01-30 14:26:44Z

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.

answered Jan 30, 2019 at 14:26

Vijay Ganji

6,6563 gold badges14 silver badges31 bronze badges

Add a comment |

2 Answers 2