function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jerome WoodsJerome Woods 

Formula to count days since last activity by status

Need a little help, Im trying to figure out a way to show the number of days since the last activity on a lead, but be able to reset the counter when the lead status changes.

Im familiar with the formula today() - lastactivitydate which returns the days since the last activity was logged but I need to take it a step further to reset the counter everytime the lead status changes
Pallavi KavarePallavi Kavare
Hi Jerome, 
This can be also done using after update trigger. 
Pallavi KavarePallavi Kavare
But if you want to use point n click only then can be done using workflow also
Jerome WoodsJerome Woods
Hi Pallavi, so for point and click its best to do with workflow?  would happen to give a bit of detail into the process?