+ Start a Discussion
3333 

Null Picklist Value Issue in Workflow Rule

Hi everyone, I would like to find a way to evaluate a picklist field against NULL value ("--None--"shown in edit page) in the workflow rule. In workflow rule, the only available function for the picklist field is "ISPICKVAL", while I wouldn't like to exclude all the non-Null values one by one.( It really has a lot of values in our field).  I tried the following ways:

 

ISPICKVAL( Category__c , "--None--")

ISPICKVAL( Category__c , "")

ISPICKVAL( Category__c , " ")

ISPICKVAL( Category__c , "(NULL)")

 

No one can really work.....Any one can help with it? thanks in advance~:smileyhappy:

IspitaIspita

Hi,

You need to convert the picklist values to text using the function text(), check the example below:- 

if( len(Text(PicklistFieldname))=0, true, "here your rest of code/formula")

 

 

Hope this helps..

3333

hi, thanks for your reply. I tried your method, but it cannot work. as the the TEXT function can only be used in the workflow rule field update formula or the validation rule.

hemantgarghemantgarg

Try this :-

ISPICKVAL( Category__c , '')