Skip to main content
Topics#Data ManagementPregunta de Philipp Mathis
Philipp Mathis ha preguntado en #Data Management
22 sept 2017, 15:43

Custom Field that is counting days since last stage change?

Hello Guys

 

I've downloaded a free dashboard from the appexchange and stumbled upon this very nice custom field:

 

days since last stage change.

 

Since the dahsboard is managed/packaged it doesn't let me to do changes. Also the owner of the dashboard is not let me do this change. Basically I'd like to create my own custom field that is counting how many days passed since there was the last change of oppty stage. So in order to have full flexibility and edit myself all time, change naming etc.

 

Would you know what the formula for such field?

 

(formula is unfortunately not visible)

 

Thanks,

 

Philipp
1 respuesta
  1. Doug Burkhart (Centric Consulting)
    22 sept 2017, 15:45
    Philipp,

     

    It's actually 2 fields. Last Change Date and Days Since Last Stage Change.

     

    Last Change Date gets updated via workflow anytime a Stage is Changed using formula:

     

    ISCHANGED(StageName)

     

    Then, Days Since Last Stage Change is a formula field:

     

    TODAY() - Last Change Date

     

    Doug
Escribir una respuesta...
0/9000