We have a task level custom field named "Sub Milestone" (internal reference is DE:tasks:Sub Milestone). We would like to create a project report to find any projects where DE:tasks:Sub Milestone=MARKETING APPROVED and that task's status is completed (CPL). I'd really appreciate any suggestions on how to accomplish that.
Solved! Go to Solution.
Views
Replies
Total Likes
can I interest you in this link?
you're already 25% of the way there with your first line. You just needed the "DE:tasks:Sub Milestone_Mod=in" line, and then 2 more lines for the status, "tasks:status=CPL" and "tasks:status_Mod=in"
Reporting on collections is super easy because for the most part you can steal all of your text mode from a task report and just put it into a project report and append "tasks:" to the front of every system line, or after the "DE:" for every custom field line. Then for the most part, your task report turns into the validation report for your project report (group by project ID, and run a quick count between the two reports)
can I interest you in this link?
you're already 25% of the way there with your first line. You just needed the "DE:tasks:Sub Milestone_Mod=in" line, and then 2 more lines for the status, "tasks:status=CPL" and "tasks:status_Mod=in"
Reporting on collections is super easy because for the most part you can steal all of your text mode from a task report and just put it into a project report and append "tasks:" to the front of every system line, or after the "DE:" for every custom field line. Then for the most part, your task report turns into the validation report for your project report (group by project ID, and run a quick count between the two reports)
Thank you for the answer! This resolves it!
Views
Replies
Total Likes