You need to sign in to do that
Don't have an account?
kjun
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!
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 ) )
AND(
ISPICKVAL( Assets__c , 'Yes'),
LEN ( Asset_Items__c ) = 0
)
Thanks,
Maharajan.C