This conversation has been locked due to inactivity. Please create a new post.
The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.
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.
1 Accepted Solution
Correct answer by
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
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.
Correct answer by
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
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.
Related Conversations
