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?
Thanks in advance!
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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/cal...
Views
Replies
Total Likes