Skip to main content
I have set up a formula field on Leads called:

 

"Date Since Last Activity" with formula: Today ( ) - LastActivityDate that returns a number.

 

It is hit-and-miss - it has calculated some numbers, and not others. I can't tell why some are calculating, and others not. A majority of the Leads do not have any email activity/tasks, but this doesn't appear to equate to whether the Date Since Last Activity field is blank or not.

 

Formula field not working

 

User-added image
3 Antworten
  1. 5. Apr. 2018, 19:45
    Here is some helpful information on how "Last Activity" is calculated. 

     

    https://help.salesforce.com/articleView?id=What-is-the-difference-between-Last-Activity-and-Last-Modified-1327108315155&language=en_US&type=1

     

    There could be activities that are not directly related to the object which are impacting the "last activity date". So they don't show in the past activity timeline for the record, but they do affect the date.
0/9000