You need to sign in to do that
Don't have an account?

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
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
Please use
Thanks,
Gaurav
skype: gaurav62990
Support: gauravgarg.nmims@gmail.com