In Reporting you can link between a Project and the convertedOpTask object and so can then also "Navigate" to the Project from which it originated. But while the Calculated Field area seems to allow you to enter it in a similar fashion, when you go to save the form, it provides a message that the fi...

To get the actual ISO Week Number the formula is:valueexpression=IFIN(DAYOFWEEK(CONCAT("1/1/",YEAR({entryDate}))),1,6,7,CEIL(DIV(DATEDIFF({entryDate},CLEARTIME(CONCAT("1/1/",YEAR({entryDate})))),7)),SUB(CEIL(DIV(DATEDIFF({entryDate}),CLEARTIME(CONCAT("1/1/",YEAR({entryDate}))),7)),1))valueformat=HTM...

Thanks Doug, yes my other column highlighted showed exactly the same potential... but not there in the IF statement.  

I want to get a column in a task report that puts the MAX date in when the task meets a criteria.  Ultimately I want a series of columns that grab the date off of a different task. I was trying a basic example but I never seem to get a date appearing in my aggregate…See simple example below aggregat...

One way is to put the details to be answered by the other group in a section that is dependent on a field that is a Yes / No Response... Something Like "Enable XYZ Department Section". If Yes then Open Section. You set the Value as No. Then the required fields are not required until the question is ...

you would replace the status in the { } with the custom field {DE:Custom Field Name}   IF({DE:Custom Field Name} < 0,"Late",IF({DE: Custom Field Name} = 0, "On Time","Early"))

similar concept i did for a client used the following formula...   IF({status}="PLD","1. Trending Early",IF({actualCompletionDate} = "",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"1. Trending Early",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, ...

Well you need a tool that is capable of automating activity. Any of these "integration" tools would do that too. Workfront does not have an inbuilt Automation engine. It relies of Workfront Fusion (or you could write a routine using the API and host it somewhere yourselves).

https://business.adobe.com/products/workfront/work-automation.html   Fusion is an iPAAS application so if your organization already has one, such as Zapier, Boomi, Mulesoft, Workato, any of these can be used

You would need Workfront Fusion