Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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))
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)
Are you just doing concat the string to field?
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))
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.
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.