Count number of days in a status | Community
Skip to main content
K
KatherineCh
Level 2
January 15, 2020
Question

Count number of days in a status

  • January 15, 2020
  • 1 reply
  • 507 views
Hello! I am trying find or build a field that will count the number of days the task has been in a specific status. Right now I have a bar chart that counts the number of tasks in each status assigned to a team. When the manager selects "On hold" to see the details of the on hold tasks, I want a column to reference the number of days each task has been on hold. Katherine Chatham
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

E
EXP_-_DustinMa
Level 8
January 16, 2020
Hello Katherine, I'd love to see this implemented one day, I do believe there is a feature request in the Idea Exchange that you can go vote on. In the mean time, I have clients that have created multiple fields for this issue. The first field being a status drop down that users update either in conjunction with, or instead of the built in status box. Then the second field is a date field that they use to select the date they changed the status. Then the third field being a calculated field that would compare $$today-second field, like an IF statement IF((Status=CUR),($$TODAY,Second Field),IF((Status=Approved),($$TODAY,Second Field))) If you want to see how long it was in each status, it becomes far more complex and I would highly advise contacting your Account Executive to get a block of remote consulting hours so they can work with you to build the custom form as you need it. Thanks! Dustin Martin Assigned Support Engineer Workfront
Terms & ConditionsAccessibility statement

Loading footer...