URL In Straight Table

[mparker123]

Hello All,

I am trying to put a URL link into a straight table. When I put in the expression the field is blank and not showing any values. If someone can take a look my expression? I would appreciate it.

=if( epic_cf_pmo_project_type='Epic' and project_name<>'PMO Test' and project_name<>'PMO IMS Pipeline' and epic_status<>'Not Required' and epic_status<>'Done',epic_key, [epic_key] & '<URL> http://google.com & epic_key)

[marcus_malinow]

Try this:

=if(ONLY(epic_cf_pmo_project_type)='Epic' and ONLY(project_name)<>'PMO Test' and ONLY(project_name)<>'PMO IMS Pipeline' and ONLY(epic_status)<>'Not Required' and ONLY(epic_status)<>'Done',epic_key, [epic_key] & '<URL>http://google.com/‌' & epic_key)

[Anil_Babu_Samineni]

Are you just doing concat the string to field?

[marcus_malinow · Accepted solution]

CORRECTION -

=if(ONLY(epic_cf_pmo_project_type)='Epic' and ONLY(project_name)<>'PMO Test' and ONLY(project_name)<>'PMO IMS Pipeline' and ONLY(epic_status)<>'Not Required' and ONLY(epic_status)<>'Done',ONLY(epic_key), ONLY([epic_key]) & '<URL>http://google.com/' & ONLY(epic_key))

[mparker123]

when i use this it works but it populates the straight table with values that should be filtered out and are filtered out with my other expressions.

[marcus_malinow]

Great, as it works, please mark my answer as correct

You'll need to add some additional criteria to base the display of this on your other expressions.