+ Start a Discussion
albonillalbonill 

ISCHANGED to send alert but not when field is blank

Hello,

 

I have created a workflow rule that will alert a specific department when a change is made to the Account Status field.  The alert works fine, but the only thing is that I don't want the email alert to trigger if the Account Status is changed to a blank field.  We have three options in the picklist, but we also allow for the field to be left empty even after it has been populated.  The workflow alert triggers is the formula evaluates to TRUE.

 

Here is the basic formula I have. 

 

ISCHANGED( Account_Status__c )

 

Thanks in advance.

 

Best Answer chosen by Admin (Salesforce Developers) 
goabhigogoabhigo

Ok ISBLANK is not supported for Picklist fields. So use,

 

AND( NOT( ISPICKVAL(Account_Status__c, '' )) ,ISCHANGED( Account_Status__c ))

 

OR

 

AND( NOT( ISBLANK(TEXT(Account_Status__c) )) ,ISCHANGED( Account_Status__c ))

All Answers

Srikant JoshiSrikant Joshi

Hey,

 

Check if Status is Not Null in the criteria,

 

AND( NOT( ISBLANK(Account_Status__c )) ,ISCHANGED( Account_Status__c )) 

 

Srikant.

 

 

albonillalbonill

Hello Srikant,

 

I input the formula you suggested,and I guess it is my fault for not specifying that we are dealing with a picklist.  I received this error message when saving:

 

Error: Field Account_Status__c is a picklist field. Picklist fields are only supported in certain functions

 

Any suggestions on how to get around this?

 

Regards,

Alexis

goabhigogoabhigo

Ok ISBLANK is not supported for Picklist fields. So use,

 

AND( NOT( ISPICKVAL(Account_Status__c, '' )) ,ISCHANGED( Account_Status__c ))

 

OR

 

AND( NOT( ISBLANK(TEXT(Account_Status__c) )) ,ISCHANGED( Account_Status__c ))

This was selected as the best answer
albonillalbonill

Thanks for your help abhi_the1.

 

Regards,

Alexis

RitchiebRitchieb

The above doesnt work, as ISCHANGED and TEXT do not support Picklist fields. Does anyone know how to trigger and email upon a change in a Picklist field?

RitchiebRitchieb

Nevermind, needed to change my workflow rule to "Every time a record is created or edited".