Hitting error on Validation Rule with a multiselect picklist

Hi,

I'm hitting an error on a validation rule using a mutli-select picklist that doesn't make any sense. The multi-select picklist field is Client_Prducts_c:

Error is:
Error: Field Type is a picklist field. Picklist fields are only supported in certain functions.

Rule is:

AND(
Type = "Customer",
AND(
ISBLANK(Client_Prducts__c)
)

But I'm using ISBLANK on the multi select picklist, which according to this thread is allowed:

https://help.salesforce.com/articleView?id=tips_for_using_picklist_formula_fields.htm&type=5

Help!

Thanks
Dan

February 1, 2018
·
Answer
·
Like
0
·
Follow
2

Maharajan C
Hi Dan,

You got the error due to the Type field which is the picklist field not related to multipicklist:

The formula should be like below:

AND(
ISPICKVAL(Type, "Customer"),
ISBLANK(Client_Prducts__c)
)

Can you please Let me know if it helps or not!!!

If it helps don't forget to mark this as a best answer!!!

Thanks,
Raj