+ Start a Discussion
Book_GuyBook_Guy 

Date/Time Stamp for picklist value change

Hi All,

 

Anytime a Picklist value changes I would like to update a timestamp field.  What logic can be used to determine that the field changes value ISChanged(Text(My Pick List field)) does not work.

 

Have a clunky way of doing this but hoping to get a more precise way.

 

TIA

 

--David

RovRov

Create a workflow,
Evaluate Rule: Ever time a record is created or Edited
Rule Criteria: Run this rule if the following formula evaluates to true

 

/* if the field has changed... */
ISCHANGED(PickListField__c )

Add Workflow Action:
Field Update: Time_Stamp_Field__c
Formula Value: Now()

 

Hope this helps.

 

 

RyanhainesRyanhaines

I am frustrated with this same issue. When I create the field update Now() I have no issues. But when I set the formula to evaluate true for IsChanged(picklist_field), I get the following error:

Error: Function ISCHANGED may not be used in this type of formula

 

I also tried what the user suggested, Ischanged(Text(Picklist_field)) and I get the same error. Help!

 

Ryan