Hey,   Looks like you are nearly there. Since you are filtering one field against another, you need to tell Workfront you are doing this by adding "FIELD:" to your filter criteria. So "assignedToID=project:ownerID" will become "assignedToID=FIELD:project:ownerID"   assignedToID=FIELD:project:ownerID...

Hi,   No, i'm afraid that this isn't possible. Tasks are classed as a collection on the project object (since a project can have multiple tasks) and it's not possible to pull the values from every task into a single field.   If the desired outcome is to pass all of the task statuses on a given proje...

Hi,   It's possible to display all tasks with a specific custom form attached in a project report, however not as clickable hyperlinks. Tasks are classed as a collection in a project report (since a project can have multiple tasks) and to my knowledge, you can't output a clickable link from a collec...

Hi,   Give the following text mode a try:   descriptionkey=durationMinutes durationunitfield=durationUnit.value linkedname=direct listsort=intAsInt(durationMinutes) namekey=duration querysort=durationMinutes styledef.comparison.leftmethod=intAsInt(durationMinutes) styledef.comparison.operator=gt sty...

Hi,   Try using the following text mode filter on a Journal Entry Report:   entryDate=FIELD:project:actualStartDateentryDate_Mod=gt   This text mode should filter to any Journal Entries where the entry date is greater than the Project actual start date.   Best Regards, Rich.

Hi,   I would have a go at creating a report on the Note object in Workfront. You can read more on this here.   You should be able to filter to notes (updates) where a specific team was tagged, as well as pull in high level information about the task or project the note was added to.   Best Regards,...

Hi   That code is correct and works in my instance.   Is the custom field you have setup a single line or paragraph text field? If you are using a formatted text field to store the URL you will likely find that this wont work.   Other things to check are: Is the URL definitley correctAre there any s...

Hi,   I don't believe this is possible whilst you are using a calculated column in your report view. Calculated columns calculate data in real time and they only exist in the view itself, the calculations are not stored anywhere for Workfront to be able to aggregate into an average or sum.   What I ...

Hey @Madalyn_Destafney,   Sure thing, this following text mode should do it. This will only return proof approvals where the overall decision is still pending on projects where DE:Region - DX Campaign Ops = "Americas"   EXISTS:1:$$EXISTSMOD=EXISTSEXISTS:1:$$OBJCODE=DOCU EXISTS:1:versions:ID=FIELD:do...

Hi Emma,   You could try creating a task report that has a primary grouping of Milestone>>Name and a secondary grouping of Parent>>Name.    This should display all tasks under each milestone and workstream in a similar way as you depict on the screen shot. You wont get the same task indentation as w...