I am trying to display on a case how many days a case has been, or was opened since after it was escalated and the formula requires me to create a "escalated date" date/time field, while this is a simple workaround, I would prefer to pull in the date automatically if possible to avoid people from changing it, and to remove the additional manual step for something that is tracked in the history. (I already have a formula created for the calculation, I just need the formula date field pulled in as well)
The formula field allows me to pick the "last modified date", but does not allow me to hone in on the change:
date status changed to "Escalated"
This information is available in the history of the case, so I am hoping it is something that I can pull in.
2 个回答
You could remove the field from the page layout. That will make it so no one can edit it, but will still be accessible for your other formulas.
Not sure if this will work, but you could try to create a workflow rule that populates a date/time field whenever the case is escalated. You can hide that field and then do a formula to subtract that date/time from NOW() or NOW(). Like i said, not sure it is possible, but just spitballig here. Good luck.
