If Statement to display project name | Community
Skip to main content
J
JeremyBu1
Level 2
December 11, 2019
Question

If Statement to display project name

  • December 11, 2019
  • 1 reply
  • 435 views
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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

S
SkyeHa
Level 10
December 11, 2019
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
Terms & ConditionsAccessibility statement

Loading footer...