Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

IF statement to display issue name

Avatar

Level 1

Hi

 

I'm trying to create a custom column in an issue report where the name of the issue only appears if the issue sits in a particular project, does anyone have any ideas on the code needed?

 

Thanks

 

Chris

2 Replies

Avatar

Community Advisor

Hi Chris,

 

The following would do it:

 

textmode=true
valueexpression=IF({projectID}="INSERT-PROJECT-ID-HERE",{name},"")
valuefield=name
valueformat=HTML

 

What this expression is saying is, If the project ID of the issue is X, then output the name, otherwise output nothing.

 

Hope that helps.

 

Best Regards,

Rich.

Avatar

Level 1

Thank you so much Rich, this worked perfectly!!