Expand my Community achievements bar.

SOLVED

I am trying to create a task report that shows: \n- How long a task was in New\n- How long a task was In Progress\n\nI'm terrible at text mode so any help is appreciated.

Avatar

Level 2
 
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

When a task status changes to In Progress, the Actual Start Date Field should fill in. If you go to this link and scroll down to: Make a calculation between two fields in a column, you should be able to pull that into a report column

https://one.workfront.com/s/document-item?bundleId=workfront-classic&topicId=Content%2FReports_and_D...

You'd want to calculate the difference between Entry Date and Actual Start Date for how long it was in New, then between Actual Start Date and Actual Completion Date for how long it was In Progress.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

When a task status changes to In Progress, the Actual Start Date Field should fill in. If you go to this link and scroll down to: Make a calculation between two fields in a column, you should be able to pull that into a report column

https://one.workfront.com/s/document-item?bundleId=workfront-classic&topicId=Content%2FReports_and_D...

You'd want to calculate the difference between Entry Date and Actual Start Date for how long it was in New, then between Actual Start Date and Actual Completion Date for how long it was In Progress.

Avatar

Level 10
Hi Meigan, I suggest you give the WFPro Text Mode articles a try: https://wf-pro.com/textmode/text-mode-views/#entry-to-complete-date-variance Narayan Raum Workfront COE @ Truist Financial