Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

If Statement to display project name

Avatar

Level 2
So I have searched the community and the help files and I am stuck. This is probably the easiest question to answer. I am trying to write a if statement to either hide or display the project name based off of a custom field. The way I would write this is: displayname=Event Name lnamekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey.1=name querysort=project:name textmode=true valueexpression=IF({DE:MC Task Type}="Event Dates",project:name,"") valueformat=HTML My column keeps displaying blanks. Im trying to learn text mode, if anyone has any suggestions as to where to start ( Ive looked at all the help files, etc) Id appreciate the advice. Thanks, Jeremy Jeremy Busch
1 Reply

Avatar

Level 10
Not really sure what kind of report you are in (is it a task report?) but I was able to get the following to show up on a project report. displayname=Event Name linkedname=direct namekey=name querysort=name textmode=true valueexpression=IF({DE:yourfieldname}="answer",CONCAT({name}),"") valueformat=HTML I think probably if you add the "concat({})" part of the equation it might start working? But I didn't really want to work through all the possibilities and it really does depend on your report type. -skye