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

I am experiencing an issue where all roles are not populating in dashboard dropdown.  Any ideas on what could be happeining?

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