You need to sign in to do that
Don't have an account?
blakeLL
Using a case status update in a formula
In a formula on a custom case field, can I use the most recent date/time stamp of when a case was changed to a certain status. For example, I want to have a formula that is based off of the last time a case was set to STATUS X.
I have professional edition. Here's my basic formula to calculate a Due Date on a case:
Case(Type,
"Problem", Date_of_Assignment__c +1,
"New Letter", Date_of_Assignment__c +2,
"New Customer", Date_of_Assignment__c +5,
),
Right now Date_of_Assignment is a manual entered field, that the user populates when they change a change from status of "Waiting on Customer" to "Escalated" or "Open".
Is there a way to determine the date and time that the case was most recently changed to "Escalated" or "Open"? Furthermore, is there a way to determine the date and time that the case was most recently changed by user1, user2 or user3 to "Escalated" or "Open"?