Expand my Community achievements bar.

SOLVED

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

Avatar

Level 2

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

3 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 7

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!