Skip to main content
Eric_D_Miller
Eric_D_Miller
Level 5
August 26, 2026
Solved

Pulling A (Linked) Tasks Into a Column Within A Project Report

  • August 26, 2026
  • 5 replies
  • 45 views

We are looking to create a report that pulls tasks into columns. The task column also needs to be a clickable/interactable link.

 

Lets says I have a task called “Banana Slamma” and I want that task to be pulled in, with a link that takes you to that task page. Is this possible via textmode?

Best answer by skyehansen

This should work, but I don’t have any tasks called Banana Slamma in my instance, so it predictably pulled up nothing.

 

displayname=Column Name
listdelimiter=<p>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({name}="Banana Slamma",CONCAT("https://yourdomain.my.workfront.com/task/",{ID}),"")
valueformat=HTML
 

I believe this will be the only way you can get a clickable link. There will not be a way to get a shorter link. If you have two bananas, they will both come in.

5 replies

Lyndsy-Denk
Community Advisor
Lyndsy-DenkCommunity Advisor
Community Advisor
August 26, 2026

You can reference a collection of tasks into a row for the project, but text mode is...arduous at best. I recommend a task report grouped by project.

Eric_D_Miller
Eric_D_MillerAuthor
Level 5
August 26, 2026

I recommended this but the customer would like the tasks displayed in columns instead 😸

Additionally, it appears a collection will not allow me to have an interactable link:

I know it’s possible to pull Milestone’s into a column, the tricky part is getting the interactable link that I really would like a solution for, if possible.

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community AdvisorAccepted solution
August 26, 2026

This should work, but I don’t have any tasks called Banana Slamma in my instance, so it predictably pulled up nothing.

 

displayname=Column Name
listdelimiter=<p>
listmethod=nested(tasks).lists
type=iterate
valueexpression=IF({name}="Banana Slamma",CONCAT("https://yourdomain.my.workfront.com/task/",{ID}),"")
valueformat=HTML
 

I believe this will be the only way you can get a clickable link. There will not be a way to get a shorter link. If you have two bananas, they will both come in.

    Eric_D_Miller
    Eric_D_MillerAuthor
    Level 5
    August 27, 2026

    This worked! In order to make this perfect I would like to be able to display custom text rather than the whole link. Is that possible?

     

    This is a project report by the way.

    skyehansen
    Adobe Champion and Community Advisor
    skyehansenAdobe Champion and Community Advisor
    August 27, 2026

    I believe this will be the only way you can get a clickable link.

     

    I asked the Claude AI and it eventually gave this as an explanation, which works as well as any:

     

    The constraint "You cannot make a collection a clickable link" specifically means: you cannot use HTML anchor tags (<a href=...>) to create a named link where the URL is hidden in the href and only the text displays as clickable.

    Terms & ConditionsAccessibility statement

    Loading footer...