Hi, Just thought I'd share. I think I got a solution to display the Week number a task starts from a Project custom field. CONCAT("Week ",ROUND(((DATEDIFF(Planned Start Date,Project.Contract Date))/7),0)) You could try something like: CONCAT("Week ",ROUND(((DATEDIFF(Planned Completion Date,Project.P...

Hi, I unfortunately don't have a solution for you. But I am looking to try and do the same thing, but I want number of weeks from a date set in a custom field. Did you by chance ever figure anything out? Thanks! Mollie Shatek JLL

Hello- We are also implementing workfront and am running into the same issue. However, from our standpoint the Change Management effort would be too great to start to ask team members to track time at a task level. So we are going to continue with monthly project time. So of the problems we are runn...

Hi, thanks for the tip! Is there some place I can find a list of the logical expressions that can be used in workfront? I think I did get my formula working: IF(($$NOW>Planned Start Date),IF(ROUND((PROD(DIV((ABS(WEEKDAYDIFF($$NOW,Planned Start Date))),(DIV(Duration,480))),100)))>100,"100%",CONCAT(RO...

Hello- I am trying to calculate a expected percentage complete for each task biased solely on current date and duration of the task. I got this single IF statement to work: CONCAT(IF(($$NOW>Planned Start Date),((PROD(DIV((ABS(WEEKDAYDIFF($$NOW,Planned Start Date))),(DIV(Duration,480))),100))),0),"%"...