The exists webinar will really help then. Super easy 8-step instructions below.
1) Pull up a task report and set up the filter you want:
* actual completion date past month
* task name contains ABC
* whatever else you normally put in that is task related, like status not cancelled, or etc.
2) switch over to text mode. Copy the filter you just made.
3) Pull up a project report.
4) Set up all your project filters you normally have, like "status not equals to cancelled" or whatever.
5) Switch this over to text mode.
6) Copy in your task filter at the bottom.
7) For all you task filter lines, append them with "EXISTS:a:"
😎 Add 2 more lines: this is the secret sauce --
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:projectID=FIELD:ID
SUMMARY: Your filter in your project report should look like this:
* all your normal project filters
plus these two lines
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:projectID=FIELD:ID
plus additional lines from your task report that look like this:
EXISTS:a:name=ABC
EXISTS:a:name_Mod=cicontains
EXISTS:a:actualCompletionDate=____
EXISTS:a:actualCompletionDate_Mod=____
EXISTS:a:actualCompletionDate_range=____
(I just made that above part up so you could see something similar to what you might have, so don't take a copy and paste of it -- use your own task report to generate and then append the exists lines)
