Hi, I think most of your functions and syntax will come from here: https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions   I'm not seeing any "MID" function, so can you please post a link to where you found that one?   Also, I...

it looks like you already know the text mode to change the ID to a name. I see a "project | owner ID" column you can pull in and do exactly that same thing.   Then, once you have it working, just copy the column and where you have the ":name" make it a ":homeTeam:name" instead.

I guess I am not clear about your original post when you said "I get nothing showing up". Both Sven and I focused on your filter, because we thought you were getting no results. Are you now saying that you are getting results, but need to additionally create a column to show the project owner?

In your current attempt, the "PORT" part indicates that you are still searching for portfolios. I suggest you start with a search for users instead, something maybe like this:   $$HOST/attask/api/v18.0/USER/search?teamIDs=______________&teamIDs_Mod=in   (please note, no parentheses needed around the...

Hi, this text mode is for a collection of project users on a project. A "listdelimiter" is the separation between your results, when you have more than one result, as is normal for a collection.   In an assignment report, you do have the ability to only have one result (each assignment is made to a ...

You can probably use EXISTS filters to get at a lot of this. However, it would depend on how you identify these requests, which isn't clear in your original post.   For example, if each of your requests uses a unique custom form, you can filter on projects which do not have a request that has custom...

@TaylorPasley  @monicacardoso -- wanted to cc you as you are close to this area -- can you think of anything else to add?

I'm sorry you're having such a poor experience with Support.   Most of the bugs I report are pretty low priority (i.e. I found a workaround) so I often don't really pay attention to how long they take. That said, I've recently gotten a few apologies for a lack of response that amount to them being s...

I'm not the best on understanding text mode, but in my limited understanding, I feel that the problem is in your order of operations. Your valueexpression is going to run first and then the valueformat is going to run after this.   For example, if the date is 3/1/25, your valueexpression will turn t...

In your first report, can you put one more column into the view? Add the owner's home team ID as a column.   Once the results come up, just check and see if any of the home team IDs are "abc123".    If there are line items where the home team IDs are abc123, there's something wrong with your code. I...