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

[Heather_Kulbacki · Accepted solution]

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.

[NRYNR]

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