Skip to main content
Topics#Data ManagementMatt Brown's Question
Matt Brown (Appirio) asked in #Data Management
Sep 5, 2012, 7:51 PM

Workflow Email Alert on a Picklist Value Change

Is there a simple formula for a Workflow rule that will fire if a Picklist value changes from one value to another? 

 

Let's say that the Picklist is called "Risk" and the values are Green,Yellow,Red and Known Loss. We want to send an email out when the value changes from any value to another value.

 

Thanks!
2 answers
  1. Shayne Lalonde (ABSG)
    Sep 5, 2012, 8:16 PM
    This should work, converts your pick-list to text and won't fire if prior value blank (which it sounds like you only want changes between values)

     

    (AND(not(text(Priorvalue(FIELDNAME )) = null), 

     

    ISCHANGED( FIELDNAME) 

Write an answer...
0/9000