I am trying to create a task report that shows: - How long a task was in New- How long a task was In ProgressI'm terrible at text mode so any help is appreciated. | Community
Skip to main content
Level 2
November 11, 2020
Solved

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

  • November 11, 2020
  • 2 replies
  • 611 views
No text available
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Heather_Kulbacki

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_Dashboards%2FReports%2FText_Mode%2Funderstand-common-uses-text-mode.html&_LANG=en

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.

2 replies

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity AdvisorAccepted solution
Community Advisor
November 12, 2020

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_Dashboards%2FReports%2FText_Mode%2Funderstand-common-uses-text-mode.html&_LANG=en

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.

Level 10
November 19, 2020
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