Topics help categorize Community content and increase your ability to discover relevant content.
Hi Justin @skyehansen resurfacing this old thread. I'm in the need of having a task report with a column for each task in a template in many projects with shared cols of that task's planned start and end date in each cell for the respective column (task).
Project name as my first column, then the subsequent columns being the task names and their start/end date as shared cols so share same cell in each row of project. Basically a matrix report but I'm not finding I can get dates in a matrix report, only hours/$.
I tried the textmode above but coming up blank, maybe bc nothing is after list delimiter?
I have this as example of 1 of the tasks I want to bring into a column:
sorry, not quite sure what you are asking for here, but keying off two items: your initial task report and the collection of nested tasks you are referencing, I will point out that this code in a task report will pull in the collection tasks IN YOUR TASK. In other words, you are trying to pull sub-tasks under each of your task lines.
If you were trying to pull other tasks in the same project, you might try the following instead:
sorry if this isn't what you're looking for... the wording is just really unclear to me for some reason.
Here's what I'm trying to do. I have consistent task names in these projects bc using a template. I want the tasks' planned start and completion date in the report cells with a line break (shared cols) to see the dates for each of these tasks with the projects. Is this possible?
This is where I need help, I don't know what I need to achieve what I want. At first I thought a task report, but not sure. I don't care if it's a task or project report, I just need to show start/end dates of tasks that exist in many projects and show their dates in their respective project like I mocked up in my screenshot.
let's just try it as a project report, if you're that flexible. Were you able to get your code working in there? What happens if you put in the list delimiter and then do a sharecol with the next col that has a plannedCompletionDate?
Holy moly I tried for 1 task and shared cols and it's working! I can add in the other tasks now as columns - I was just starting with a task report when all along I needed a project report. Next curveball - how to do I get the % complete to be that task's % complete, not the project's, and how do I add a column for task status??
it's the same thing as your initial code. A bunch of collections columns, with valueexpressions like:
Ah I see. Thank you. I started adding more and seeing an obstacle. I have multiple tasks within same projects named exact same thing ,not just same task name across separate projects. Is there a way to indicate parent task in the value expression? Like can I pull in round 1's 'QA against bible....' task vs. same task under round 2, round 3, etc? We have 4 rounds in each project. Thank you for your help!!
if you go into the API explorer for the task object, you'll see in the reference tab, a line item for "parent" so my guess is you'll have to go back and re-tool your valueexpression to incorporate "if parent name = " round 1, round 2, and so on.