Add a Column to a Report to show specific task due dates | Adobe Higher Education
Skip to main content
MattEl5
MattEl5
Level 3
September 24, 2024
Pergunta

Add a Column to a Report to show specific task due dates

  • September 24, 2024
  • 4 respostas
  • 1486 Visualizações

HI Folks, 

 

Racking my brain to figure this out but cant and not sure if it can be done. 

In a report (project) can i add a column where it pulls in the Start/Due date of a specific task? 

 

I cant find anything standard to pull in Task info into a project report. And i cant make a task report behave the way i want with columns to show the Start or Due date. 

What i want is to have a report where a single project is on a row. 
In the columns there are selected tasks (hopefully using something like "task name contains - Schedule meeting") and one column has the start, and one the due date. 

Can this be done using text and how?  Thanks!! 

4 Respostas

skyehansen
Community Advisor
skyehansenCommunity Advisor
September 24, 2024

You can do this through using collections. Here's a good example that shows you how to bring in the due date. It's actually 2 examples, one for a parent task and one for a child task.

 

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/add-column-in-project-view-representing-the-planned-completion/m-p/483425#M16194

 

You can use similar syntax to bring in start dates.

MattEl5
MattEl5Autor
Level 3
November 1, 2024

Hi Skye, i appreciate you sharing, i took a look at a few of the collections posts youve put inhere. 
some really good text language, but it doesnt have the functionality i was looking for. Ideally i would like it to be editable (move dates, and for an assignment column, be able to switch them out, which is a stretch i know! 

The other issue is not wanting to use milestones as were trying to use that elsewhere! 

Thanks again for your help! 

A
AmyReilly
Level 4
September 24, 2024

This is the code we use to pull the planned completion date for a task in the project called "Input Date".  You could add another column with planned start date.  Hope this helps!

 

displayname=Input Date listdelimiter=<p> listmethod=nested(tasks).lists shortview=true textmode=true type=iterate valueexpression=IFIN({name},"Input Date",{plannedCompletionDate},"") valueformat=HTML

 

    MattEl5
    MattEl5Autor
    Level 3
    November 1, 2024

    Hi Amy, thanks for this, i think its the closest ive seen but its still not showing any data in the project report. 

    Is there a chance the syntax is off with the double "" at the end? 
    wondering what might be causing the blank ness. thanks! 

    Srinija_N
    Srinija_N
    Level 7
    October 18, 2024

    The project details can also be pulled into Task report. You can apply filter on Task name with contains/equal condition depends on the requirement and you can group by Project and also add the project start and end dates and can relabel the field names to differentiate all the dates. Attaching some screenshots for reference. Hope this is what you are looking for.

     

     

      MattEl5
      MattEl5Autor
      Level 3
      November 1, 2024

      Hi Sri, not exactly. what they want is a project report, where they have a list of all the projects going down the page, then across the page are the dates for 2 specific tasks, and the people assigned to them. ( in seperate columns)

                           Copy Due |   Copywriter   |   Design Due   | Designer 
      PROJECT  |  

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        September 1, 2025

        @mattel5 just checking in! Were you able to get this resolved? If one of the replies above helped—whether it completely solved the issue or simply pointed you in the right direction—marking it as accepted can make it much easier for others with the same question to find a solution. And if you found a different way to fix it, sharing your approach would be a great contribution to the community. Your follow-up not only helps close the loop but also ensures others benefit from your experience. Thanks so much for being part of the conversation!

        Kautuk Sahni
        MattEl5
        MattEl5Autor
        Level 3
        September 2, 2025

        Hey Kautuk. Sadly none of these have provided an adequate simple solution. Its ongoing. I would like to close it, but i dont feel that any of these have provided a solution that works. thanks for checking in! 

        skyehansen
        Community Advisor
        skyehansenCommunity Advisor
        September 2, 2025

        Just want to follow up with this comment. According to everything the OP has posted in response, the sum total of the ask is: 

         

        * they want a project report

        * they want due dates of a task

        * they want to see task assignees

        * they want this to be editable

         

        This is not possible at this time.

        1) in a project report, task information is not editable

        2) in a task report, you can't have two tasks occupy the same line and have them both be editable

         

        The closest possible solution is to use a task report, group by project name, and have each task on its own line so you can edit the assignees and the task dates.

        Otherwise, you can take this out of the task lineup, include everything you need as project custom fields, and engage your editing there (it won't update tasks, unless you also engage fusion automations to do so).

          Termos e condiçõesAccessibility statement

          Loading footer...