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