The challenge is, depending on the status change to certain vaules, it is considered completed on time.
I can currently do it in Excel based on the object's hisorical report and when the new value of the Stats was changed to the specific value. I cannot filter old values and new values in the Sf report itself though. Is there any way around it?
1 answer
You could create Workflow Rule Field Updates to set custom Date fields based on the status change -- something like "Date Opened", "Date of Demo", "Date of Resolution". That would put all the important dates on the record itself making Date math really easy.