How to make the parent account field mandatory based on picklist value?

Question

Hello,

I would like to make the Parent Account field (standard lookup field) mandatory if the Industry field (custom picklist field) is equal to "Global In-house Center (GIC)".

I've created the following validation rule on the Account level:

AND(

Ispickval( Industry ,"Global In-house Center (GIC)"),

OR(

Isblank( ParentId )))

But nothing happens, I don't get an error if or if I don't add GIC as the industry.

Thanks,

Boshra

Ankush Agarwal · Accepted Answer

Hi Boshra,   You can try below formula:   AND(   Ispickval( Industry ,"Global In-house Center (GIC)"),   IsBlank(ParentId)   )

Ankush Agarwal · Answer

Then you need to validate API name of  Global In-house Center (GIC )   picklist value.   You can go to Industry field and see the API name of this value. It should be API name of this value instead of value itself.

How to make the parent account field mandatory based on picklist value?

Data Management

関連学習

さらにヘルプを表示