In Tasks, is there a way to display a t-minus weeks schedule in a column in one of my views? | Community
Skip to main content
RED1
RED1
September 7, 2023
Question

In Tasks, is there a way to display a t-minus weeks schedule in a column in one of my views?

  • September 7, 2023
  • 2 replies
  • 542 views

Hi Community,

 

At the project level in tasks, is there a way to display T-Minus weeks in a column in one of my views?

  • It would be great to quickly view how many weeks out I am from a Go Live date based on the task that I'm currently working on.
  • If not in tasks, is there an alternative?

Thanks in advance! 

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

2 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
September 7, 2023

You could probably achieve this in a value expression in a column of your task view. But, do you have a consistent task in projects that you’d consider your live date/task? You’d need something for your expression to reference consistently to know what to count backwards from.

If this helped you, please mark correct to help others : )
Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
September 8, 2023

With text mode, give something along this line a try

 

displayname=Column Name Here
textmode=true
valueexpression=(WEEKDAYDIFF({project}.{DE:Go Live Date},$$TODAY))/5
valueformat=HTML

 

this assumes your Go Live Date is a custom field on your project, if it's a date somewhere else, this will need some tweaks

the WEEKDAYDIFF returns the number of weekdays between two and the /5 divides those days by a week dates: https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions.html?lang=en

Terms & ConditionsAccessibility statement

Loading footer...