Thanks Skye! I was on this track as well, but couldn't figure out if I needed to connect to the Project Object (my original thought) or the User Object (my second thought). And the ID=FIELD:projectID always trips me up. And, as usual, your textmode worked perfectly for my use case!

I would like to filter an assignment report by the Project Owner's Home Team. Something like this:project:owner:homeTeamID = 5deaa5330076f8ebbf6b32fd0d1b0ba8project:owner:homeTeamID_Mod = in This filter does not appear to work though. Any ideas? 

Have you tried $$USER.{name} ?

From my understanding, the LastNote column is just that, only the Last Note. You cannot report on items in the rest of the update stream. I would LOVE a way to do this though!

Thank you Skye!Here's what I ended up with that worked! This pulls in PROGRAMs to the report where any project within the PROGRAM has the custom date set between 1/1/24 and 12/31/24. (you do not need the carrots (<>), they are just there for emphasis in the forum post. ) EXISTS:A:$$EXISTSMOD=EXISTS...

I'm admittedly pretty terrible with the EXISTS filter. Trying to get better of course. Can anyone tell me what I'm doing wrong? I'm running a PROGRAM report, and I'm trying to pull in PROGRAMs that have PROJECTs where a PROJECT level custom date field is within a range. Here's what I'm trying to use...

Did you ever figure this out?

This is a pretty advanced question, I assume, but here goes nothing. We have created a "database" of sorts within Workfront using Projects. We have a single campaign that houses all of the projects and within those, they all have a custom form attached with a particular set of fields. I want to use ...

Is there a way I can REQUIRE users to assign their projects to a Portfolio? My only solution is to force them to use a Project Template and preassign the Portfolio there. Any other solutions?

Looks like I was correct. You cannot use the "Estimate" field in this manner. Instead I had to do math based on the workRequired field instead. Final code that is working looks like this:   displayname=Sizetextmode=truevalueexpression=IF((({workRequired}/8)/60)<=1, CONCAT("Extra-Small (",(({workRequ...