Workfront Reporting: Days Until Due | Community
Skip to main content
June 24, 2024
Question

Workfront Reporting: Days Until Due

  • June 24, 2024
  • 1 reply
  • 1430 views

I'm looking to add a column to a task report that calculates the number of days until the planned completion date. I've been playing around with various formulas but haven't quite figured it out.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
Community Advisor
June 24, 2024

can you share what you've been playing with? There are a number of different ways to achieve what you're looking for, as far as I know.

 

You should have picked one of the formulas from the calculated data expressions help article:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions

You could have gone with DATEDIFF, WEEKDAYDIFF, or WORKMINUTESDIFF, for example.

 

You should have picked one of the wildcard variables from the wildcards help article:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/report-elements/understand-wildcard-filter-variables

(either $$TODAY or $$NOW)

 

You should know to express your field as camelCase and in curly braces.

 

Assuming a standard scenario, this might boil down to something like WEEKDAYDIFF($$TODAY,{plannedCompletionDate}) -- but like I said... there are lots of other options that really depend on what you're looking for.

CindyTr1Author
June 25, 2024

Hi! Thank you for your response. I tried using what you shared... but the column is still showing up empty without any data. I would imagine this is a standard scenario - I'm just looking for the number of days until planned completion date (weekends included). I have the planned completion date column renamed to "Due On" but I don't believe that would impact the formula?

skyehansen
Community Advisor
Community Advisor
June 25, 2024

have you considered putting in a valueformat line? e.g. valueformat=HTML is a popular line to add.