How do I include multiple Project custom fields into a single column in a Task Report

[JeremiahBo]

I have a task report that I need to surface a few project custom fields. I am hoping to use a CONCAT to add a number of the fields together into a single column in the report, but I'm sure I have my syntax messed up. This is what I have so far.

displayname=Test Domain Releases

listdelimiter=<div>

listmethod=nested(project).lists

textmode=true

type=iterate

usewidths=true

valueexpression=CONCAT{DE:Test Domains Enabled},": ",{DE:Release Cadence})

valueformat=HTML

width=200

[AnthonyIm · Accepted solution]

Hi Jeremiah,

The text mode you have is for a collection (something that is one to many). If I understand your request, you need to reference as a task only belongs to one project, not many.

(You'd use a collection if you were doing a Project report and wanted to have info from various tasks into one column)

Try...

displayname=Test Domain Releases

textmode=true

valueexpression=CONCAT({project}.{DE:Test Domains Enabled},": ",{project}.{DE:Release Cadence})

valueformat=HTML

width=200

[JeremiahBo]

Thanks, Anthony and Sarah,

This works!

[SarahNa]

Hey Jeremiah,

Try this:

displayname=Test Domain Releases

textmode=true

usewidths=true

valueexpression=CONCAT({project}.{DE:Test Domains Enabled},": ",{project}.{DE:Release Cadence})

valueformat=HTML

width=200

Hope that helps!