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개
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
