You need to sign in to do that
Don't have an account?
saarbo
Days Since Last Activity Formula
Hello,
I need to add a field to the lead detail page which calculates the number of days since the last activity for a lead. This formula would return a number which represents the number of days since the last task has been created, updated or completed. Does anyone know what this formula is?
Thanks,
Scott
Should be
TODAY() - LastActivityDate
All Answers
Should be
TODAY() - LastActivityDate
Thanks! Looks like this works.
You might want to mark the solution as solved.
I got this error when I try to check the challenge.
Any help appreciated
Thanks in advance.
@Brian Heger: it works, thanks :)
"Moral": Be 'tenacious', 'work' almost for half an hour and do not create custom object
"Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date"
when trying all of these solutions.
Who would have thought formulas would be so difficult? I'm stuck on this trail now.
TODAY() - Account.LastActivityDate
I am using this field but there's something I don't understand. Do you know exactly what is called activity? What is updating this field (call, emails, task, note...)? Because sometimes I can see that the account have no activity since 59 days but the commercial team sent an email to someone under this account 2 days ago. If we insert a note to a contact it is the same, this field does not update. If we log a call or create a task it s working fine. I am a little confused.
Thanks for the help.
There are emails in my feed, but days since last activity are not counting them. Is there something that needs to be done?