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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
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
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
Thanks, Anthony and Sarah,
This works!
Views
Replies
Total Likes
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!