Calculate turn time from request entry day to resolve project's task completion date | Community
Skip to main content
K
Kasey-Gagne
Level 5
February 13, 2023

Calculate turn time from request entry day to resolve project's task completion date

  • February 13, 2023
  • 1 reply
  • 635 views

I am trying to pull a report that is showing us the difference (excluding weekends & holidays) from when a request is submitted (Request > Entry Date) to when one of our specific tasks within the Resolve Project is marked as complete (task name = Send to Requestor for Approval).

 

Essentially we're trying to track the turn times from request submission to the delivery to the requestor - however we have additional tasks that follow our "Send to Requestor for Approval" task that we do not want to account for so the project's Actual Completion Date would not work for us, it will need to be that particular task.

 

Any help is appreciated 🙂

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

D
DawnmarieD
Level 5
February 14, 2023

I have a similar situations but within a request.

 

We are looking to see # of days a request is with a specific role/person. The process is that a request comes in - management assigns it and then the assignee requests approval via an approval process (Ready to Proof) - Management approves and resolves the request. I would be happy if I could get the number of day entry to request for approval.

 
WEEKDAYDIFF({entryDate},{approvalStartDate})
 
Thank you in advance.

 

 

Terms & ConditionsAccessibility statement

Loading footer...