You need to sign in to do that
Don't have an account?
albonill
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.
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
Hey,
Check if Status is Not Null in the criteria,
Srikant.
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
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 ))
Thanks for your help abhi_the1.
Regards,
Alexis
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?
Nevermind, needed to change my workflow rule to "Every time a record is created or edited".