Has anyone successfully been able to report on current days in process for a project? I'm basically looking to show how many days a project has been in process from the start date. Seems simple, but I've been told that there isn't a way to do this! | Community
Skip to main content
Level 2
June 17, 2021
Question

Has anyone successfully been able to report on current days in process for a project? I'm basically looking to show how many days a project has been in process from the start date. Seems simple, but I've been told that there isn't a way to do this!

  • June 17, 2021
  • 1 reply
  • 590 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.

1 reply

SamanthaIsin
Level 7
June 18, 2021

Super simple. I would just do a calculated field in a custom form. You'll need to make sure that custom form is applied to the projects you want to see this on.

Here is the calculation:

WEEKDAYDIFF(Entry Date,$$TODAY)

Here is a doc on creating calculated fields: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-custom-fields-calculated-columns.html&_LANG=en

You could also do a calculated column in a report, but the benefits of having this in a custom form are pretty significant.

SamanthaIsin
Level 7
June 18, 2021

You can change the entry date to the actual start date easily. Just replace 'Entry Date' with 'Actual Start Date'

We use entry date because we don't always have a good grasp on when ur projects are actually started, but they're in our court as son as they're entered.