Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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

Avatar

Level 2

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!! 

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

6 Replies

Avatar

Community Advisor

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-repr...

 

You can use similar syntax to bring in start dates.

Avatar

Level 2

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! 

Avatar

Level 2

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

 

Avatar

Level 2

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! 

Avatar

Level 4

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.

SrinijaNa2_0-1729264563651.pngSrinijaNa2_1-1729264581679.pngSrinijaNa2_2-1729264608550.png

 

 

Avatar

Level 2

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  |