Hi - so you are on a different object type and need to reference the task now (since assignments are both on tasks and issues). valueexpression=WEEKDAYDIFF({task}.{plannedCompletionDate},{task}.{actualCompletionDate}) Same for the grouping. Just need to add {task} and a period in front of every fie...

Hi Sherri - have you looked at an Assignment report instead? With an assignment report, if a task has three assignees, the task is listed three times. (While in a task report, you can only group by the Task Owner's info) You can then filter Role ID = PM or IPM and not even have to worry about the o...

For them, it was just the Creative Brief for the entire campaign. So just one document. However, if you have multiple, you could always use the URL for the document area of the main project instead of the URL for the one document. So use https://anthonyimgrund.my.workfront.com/project/6091406f0049c...

Hi - I had a client once who kind of did the same thing. The difference: once uploaded, they copied the document URL and put it in a custom form on the Program. That way they could easily include it on different project. valuefield=program:Creative Brief URL You can also then do something like th...

And just to add on to Tracy's... FCB uses queue topics and routing rules on every project as there are a lot of requests that go out to shared services teams and a separate request queue just doesn't make sense . (So much information is already on the project, the requester doesn't need to re-add it...

Thank you, Sarah! Was running into this issue and glad I found this :)

Hi - since it is a project report, you will need to do an EXISTS filter so you can go to the assignment object type (not just task). Here is one I have saved. EXISTS:1:$$OBJCODE=ASSGNEXISTS:1:assignedToID=$$USER.IDEXISTS:1:assignedToID_Mod=inEXISTS:1:projectID=FIELD:IDEXISTS:1:task:status=CPLEXISTS...

Hi! Try this :) EXISTS:1:$$OBJCODE=QUEDEXISTS:1:ID=FIELD:queueDefIDEXISTS:1:project:status=CPLEXISTS:1:project:status_Mod=notinEXISTS:2:$$OBJCODE=QUEDEXISTS:2:ID=FIELD:queueDefIDEXISTS:2:project:status=DEDEXISTS:2:project:status_Mod=notin

Hi Tracy - you can do both a Queue Topic report (which has a Parent Topic Group field you can group by). There is also a Topic Group report itself as well. The biggest think is that both need some text mode to display the project name. (which is the same for both object types) displayname=Projectq...

Hi - I had a client ask for the Actual Completion Date to be displayed but not in-line editable and this worked displayname=Actual Done Ontextmode=truevalueexpression=CONCAT({actualCompletionDate})valueformat=HTML for you, the CONCAT would be CONCAT({DE:Date Needed By}) since it is a custom field I'...