@Nichole Vargas‚ Thank you again. I didn't realize the difference in letter case between the reporting and calculated fields. I think I've got it all working now.

@Nichole Vargas‚ the value expression syntax you provided did exactly what I needed. I thought I could take that same logic into a calculated field, but something isn't working. When I use {portfolio:DE:ClientWorkstream} or {portfolio:ClientWorkstream} in the field, I get the portfolio name return...

That's what I needed. I didn't realize the DE had to directly modify the custom field. Makes sense.

Thanks @Nichole Vargas‚. I should have been more clear in my post, but my issue isn't with the logic on the IF statement but the syntax on how, within a project report, to reference a field from a custom form that project's program in a valueexpression. I thought one of these would work, but neith...

Our portfolios and our programs have a custom form with a custom field that designates what division (Workstream) of the company that work belongs to. I am trying to build a project report that displays the program Workstream value if present, but displays the portfolio Workstream value if there is ...