Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

Reporting - Text mode: I show two sources in one column: Project Name and the associated task (= source). Is there a way to insert an if-condition in text mode: If my source is the same as the project, it won't show up? Thank you.

Avatar

Level 2

If I don't assign an issue to a task, the project name is automatically displayed as the source. I don't want to see it twice in one field. So I want to add a condition that the project name will only be displayed if the project name and source are the same. Is that possible? Thank you for your help.

Below you can see how I merged the project name and source into one, but without the if-condition and both are always displayed:

column.0.descriptionkey=project:name

column.0.displayname=Project | Task

column.0.linkedname=direct

column.0.listsort=intAsInt(project:name)

column.0.namekey=project:name

column.0.querysort=project:name

column.0.sharecol=true

column.0.textmode=true

column.0.usewidths=true

column.0.valuefield=project:name

column.0.valueformat=int

column.0.width=100

column.1.displayname=Project | Task

column.1.sharecol=true

column.1.textmode=true

column.1.value=<br><br>

column.1.valueformat=HTML

column.1.width=1

column.2.displayname=Project | Task

column.2.linkedname=direct

column.2.namekey=source

column.2.querysort=source

column.2.textmode=true

column.2.tile.name=component.referenceobject

column.2.valuefield=source

column.2.valueformat=HTML

column.2.width=80

Topics

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

4 Replies

Avatar

Level 7

What type of report are you building?

Avatar

Level 7

Is source a custom field that you built? How does that field get populated?

Avatar

Level 2

0690z0000098AX6AAM.png0690z0000098AWmAAM.png‚I am using the custom field "issue >> source". In my environment we renamed issue = action.