Skip to main content
Topics#Data ManagementRyan Coleman's Question
Ryan Coleman (Ellie Mae) asked in #Data Management
Jan 14, 2016, 10:20 PM

Adding number to field when date field is changed

Hello all,

 

I have found similiar posts to this but cant seem to get it to work because its a date field? (at least what I can tell)

 

I have a date field (titled "Account Review") that marks the last time an account was reviewed that is manually updated by users, I have a number field (titled "# of Account Reviews) that I want to add "1" every time the "Account Review" date field is changed. 

 

I currently have a WFR that has criteria of ICHANGED(Account_Review_c) = TRUE, with a field update of "of_Account_Reviews_c +1". However, although this seems to be the right logic, I cant seem to get the field to add 1 everytime I change the field.
3 answers
  1. Till Klotz (EMPAUA)
    Jan 14, 2016, 10:43 PM
    Hi Ryan,

     

    I think this solution is the right one for you:

     

    You can create a custom number feild and set the defualt value to zero.  Then create a WFR.  Your formula would look something like this

     

     

     

    AND( ISCHANGED(Your_Custom_Field__c), NOT(ISBLANK(Your_Custom_Field__c)) )

     

    Then you create an immediate action of a field update.  And your formula for the field update would be 

     

     

     

    Your_Custom_Number_Field__c + 1

     

    So this increases your number field by 1 each time your custom field is changed to a non null value.

     

    https://success.salesforce.com/answers?id=90630000000CjYkAAK

     

    Best,

     

    Till
Write an answer...
0/9000