How do I make the value within the column an active URL to click on?

Hi, I'm trying to do the same thing, and have spent a few hours trying to achieve what was provided by Matt and Benetta, but I just can't it to work. I will describe what I'm trying to acheive and what I have got in place. I'm creating an issue report. I have a custom field on the Project called "Termsheet Location". In the "Termsheet Location" field on the project I am storing a URL that is a link to a Sharepoint folder. On the issue report I want to have a column called "Termsheet Link" that will have a shorten link to the URL. The clickable value in the column should be called "Link" The conditional logic part is working, and when a URL is populated in the project custom form field (Termsheet Location) the work "Link" is appearing in the Termsheet Link column on the issue report. The only problem is that the "Link" value on the report is not a hyperlink and i can't click it. I will attach the text mode that I'm using, and I believe this is an exact copy of what Matt shared, so i'm not sure why it isn't working. Can anyone advise where I'm going wrong? It's frustrating that I appear to be very close. Is it possible that I have to reference the URL via a calculated field? Thanks Richard Richard Petley Coretexa

Benetta, The initial problem I notice is that you need to update the calculated field with your domain. Right now you still have mine: CONCAT("https:// streamco .my.workfront.com","/","project/view?ID=",ID,"&activeTab=form-customdata") Change the bold part to your Workfront domain. After you make the update, be sure to scroll down and check the "Update Previous Calculations" box . . . then click DONE. And then Save & Close on whole form. Finally, just for good measure, I make the project that I'm testing with recalculate its timeline as well. Take these steps first and see if it works then. In Reply to Benetta Perry:

Matt, I have attached everything. Thank you.

Matt, I have attached everything. Thank you.

Benetta, happy to help. Would you mind posting your code for both the calculated field you added and the code you have for column? Thanks! In Reply to Benetta Perry:

Matt, I put this code in a column of a project report - but my column has no data in it. I created the calculated field on one of my custom forms first, then ran the report. The column is blank. Thanks for your help.

Matt, I put this code in a column of a project report - but my column has no data in it. I created the calculated field on one of my custom forms first, then ran the report. The column is blank. Thanks for your help.

Attaboy Matt! Congratulations and thanks for sharing. Take the rest of the day off: you deserve it. Regards, Doug

Finally got it! So the history on this for me... I was trying to get a concatenate hyperlink to shorten URL of the PROJECT’s custom form but on a Task report. The reason for doing this is all our important information for each project exists at the project level, but a number of clicks it takes our users to get there is a huge overall organization complaint. They have a task report on the dashboard they use and have expressed quite vocally that having a quick link to the PROJECT’s custom form would be ideal rather than the several click process it now takes to get there. So what I first implemented was adding a calculated field on the custom form on all the projects which provides a link to the custom form. The field is called “Project Custom Form” and the calculation is as follows: CONCAT("https://streamco.my.workfront.com","/","project/view?ID=",ID,"&activeTab=form-customdata") And this works with this code on a PROJECT level report with this code: case.0.comparison.icon=false case.0.comparison.leftmethod=DE:Project Custom Form case.0.comparison.lefttext=DE:Project Custom Form case.0.comparison.operator=cicontains case.0.comparison.operatortype=string case.0.comparison.righttext=https: case.0.comparison.truetext=View displayname=Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(Project Custom Form) linkedname=direct namekey=Project Custom Form querysort=DE:Project Custom Form styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:Project Custom Form styledef.case.0.comparison.lefttext=DE:Project Custom Form styledef.case.0.comparison.operator=cicontains styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=https: styledef.case.0.comparison.truetext=View textmode=true valuefield=Project Custom Form valueformat=customDataLabelsAsString width=150 It will give me a column labeled “Custom Form” with “ View ” links for each project that open the custom form in a new window. That’s all great and working fine - but it’s one level too high. We need it on tasks -- remember. However, I thought this would be helpful for anyone who wanted it on the project level as well. Onto actually solving the problem at hand... On a Task report, I was able to use this code to get the full link, completely hyperlinked to open in a new window, for the PROJECT’s custom form for each Task --- and that works, but it’s the full link which is very long: displayname=Project Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(Project Custom Form) linkedname=direct textmode=true valuefield=DE:project:Project Custom Form valueformat=HTML And now, finally after trail-and-error and a ton of research, I was just able get it to work on Task Level by using this code: case.0.comparison.icon=false case.0.comparison.leftmethod=DE:project:Project Custom Form case.0.comparison.lefttext=DE:project:Project Custom Form case.0.comparison.operator=cicontains case.0.comparison.operatortype=string case.0.comparison.righttext=https: case.0.comparison.truetext=View Project Custom Form displayname=Project Custom Form link.isnewwindow=true link.url=customDataLabelsAsString(project.Project Custom Form) linkedname=direct namekey=Project Custom Form querysort=Project Custom Form styledef.case.0.comparison.icon=false styledef.case.0.comparison.leftmethod=DE:project:Project Custom Form styledef.case.0.comparison.lefttext=DE:project:Project Custom Form styledef.case.0.comparison.operator=cicontains styledef.case.0.comparison.operatortype=string styledef.case.0.comparison.righttext=https: styledef.case.0.comparison.truetext=View Form textmode=true valuefield=project.Project Custom Form valueformat=customDataLabelsAsString width=150 Now I have a column called "Project Custom Form" on the task report and for each task it has a link that says "View Project Custom Form" (I will probably shorten this) that links directly to the PROJECT's custom form in a new window/tab in a single click.

I'm having this same problem on a Task Report (which is where I need it) -- Project Report seems fine. I can get the full link to work (pulling from calculated custom field on the project level), but I don't want it to show the very long link. Instead, I want it to hyperlink the replacement text. So basically, in my case, it would say "View Form" be hyperlinked to the form utilizing the link from the calculated custom field. Does anyone have ideas? Am I just missing something? In Reply to Yannick Seifert:

Hi Adina, Did you manage to get this done in a task report. I can have the link clickable but when I try to replace by a custom text it does not work anymore. This is my code for that work to make a url (pulled from project custom form) clickable in a tasks report: displayname=Folder link.isnewwindow=true link.url=customDataLabelsAsString(Edu file folder path) linkedname=direct textmode=true valuefield=DE:project:Edu file folder path valueformat=HTML

Hi Adina, Did you manage to get this done in a task report. I can have the link clickable but when I try to replace by a custom text it does not work anymore. This is my code for that work to make a url (pulled from project custom form) clickable in a tasks report: displayname=Folder link.isnewwindow=true link.url=customDataLabelsAsString(Edu file folder path) linkedname=direct textmode=true valuefield=DE:project:Edu file folder path valueformat=HTML Yannick WebMD Global

I have not tried linking anything besides the URL field or calculated field that contains a single link. Maybe someone else can chime in?