My team is looking for a way to dynamically display a color indicator field based on case status AND last modified date. I know how to do this using formula fields and images for case status alone but not sure how to incorporate that last modified date in as well. Some of our statuses already dynamically update based on actions- i.e. Reply Received when a customer replies to an agents email or "Waiting" once an agent sends an email and is awaiting a reply from the customer.
Here is the criteria for the indicator: Green - 1hr or less (from time created) Yellow - more than 1hr to 2hrs Red - 2hrs and up
the indicator color resets when status changes.
If anyone can shed some light or assistance it would be greatly appreciated.
6 réponses
