I am trying to create validation rule, when closing the case if product type and component and subcomponent is empty to fill the values.
AND( OR( ISBLANK(TEXT(Product_Type__c)), ISBLANK(TEXT(Component__c)), ISBLANK(TEXT(Sub_Component__c)) ), ISBLANK(Account.Name) , ISPICKVAL( Status, "Closed"), RecordType.Name = "Support Case")
I have given defalut value as None in picklist fields.
This doesnt detect the null value for picklist values, not able to figure out why. Can some one please help what I am doing wrong.