Formula
AND(
ISPICKVAL( RMA_Reason__c , 'Hardware Defect'),
ISBLANK( Reported_Failure__c ))
Both fields are picklists.
Error Field Reported_Failure__c is a picklist field. Picklist fields are only supported in certain functions
ISBLANK is a valid function for a PICKLIST field.
I am trying to ensure of someone chooses Hardware Defect as the RMA reason, they choose the Reported Failure.
Can someone help meundertsand why this is not working?
Thank you
Shari
답변 3개
AND(
ISPICKVAL( RMA_Reason__c , 'Hardware Defect'),
ISBLANK( TEXT(Reported_Failure__c ))
)
Give that a try.