Skip to main content
Topics#Data ManagementWillie Mullen's Question
Willie Mullen asked in #Data Management
Apr 24, 2012, 3:36 PM

Automatic field update based on another field

I have a field called "# of Jobs Currently Posting" that is updated frequently by our Acct. Managers. Below that, I want to have a custom Date field that says "As of..." that automatically populates with a date whenever "# of Jobs Currently Posting" is changed.

 

I tried a Custom Field-->Formula but the ISCHANGED() function was not an option. I assume a Workflow would work but I don't know how to set the criteria properly.

 

Appreciate the help!
2 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Apr 24, 2012, 3:42 PM
    In the WFR you would set the evaluation criteria to "Every time the record is created or editied" then use the Formula 

     

    ISCHANGED(Num_Jobs_Posting)  

     

    and a Field update using either NOW() or TODAY() depening on whether you're using a DateTime field or a Date field. 
Write an answer...
0/9000