+ Start a Discussion
kjunkjun 

Validation Rule for picklist and other field

Hello, 

I have a validation rule where the Picklist value = Yes, the text area field Assets Items should not be blank. The below VR is prompting that "Data Missing" Asset items are missing! when I complete the Assets Items field. 
Any idea how to modify the VR? 
Thank you!
 
AND(
    ISPICKVAL( Assets__c , 'Yes'),
    ISBLANK( Asset_Items__c )
)


 
Best Answer chosen by kjun
Maharajan CMaharajan C
Hi,

AND(
ISPICKVAL( Assets__c , 'Yes'),
LEN ( Asset_Items__c ) = 0
)

Thanks,
Maharajan.C