Expand my Community achievements bar.

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

Avatar

Level 1

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.

2 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

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