You need to sign in to do that
Don't have an account?
Himanshu Puranik
Picklist Validation rule not working
Hello,
I have a validation rule setup to check if a given picklist value is empty. I have tried following ways but the rule does not trigger:
#Type 1:
NOT(ISBLANK(TEXT(text_field)))
&&
ISBLANK(TEXT(picklist ))
&&
(RecordType.Name = "name1"
||
RecordType.Name = "name2"
||
RecordType.Name = "name3"
)
#Type 2:
AND(ISPICKVAL(Picklist , ""), NOT(ISBLANK(TEXT(Text_Field))),OR(RecordType.Name = "name1", RecordType.Name = "name2", RecordType.Name = "name3" ))
Please let me know why this doesn't work. Thanks a lot
I have a validation rule setup to check if a given picklist value is empty. I have tried following ways but the rule does not trigger:
#Type 1:
NOT(ISBLANK(TEXT(text_field)))
&&
ISBLANK(TEXT(picklist ))
&&
(RecordType.Name = "name1"
||
RecordType.Name = "name2"
||
RecordType.Name = "name3"
)
#Type 2:
AND(ISPICKVAL(Picklist , ""), NOT(ISBLANK(TEXT(Text_Field))),OR(RecordType.Name = "name1", RecordType.Name = "name2", RecordType.Name = "name3" ))
Please let me know why this doesn't work. Thanks a lot
You can check picklist field is empty by using below code :
IF(ISPICKVAL( Test__c, '') , true, false)
Here Test__c is picklist field.
Thanks,
Foram Rana