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 help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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.
You can use similar syntax to bring in start dates.
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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 |
Views
Replies
Total Likes