Report: Show me child tasks ONLY if the parent is In-Progress

Allen4480

Hello,

I'd like to build a report.

My goal is to see only "Milestone" tasks (of any status), but only when the Parent Status is "in-progress".

I can't seem to find the right combination of filters to build this report? Can you help?

thank you tons!

Paul Newcome

You would need a helper column that brings the parent status onto each row. You would then filter the report by this helper column and the activity type column.

Paul Newcome

You would need a helper column that brings the parent status onto each row. You would then filter the report by this helper column and the activity type column.

Allen4480

Paul, you're a genius! Tell your boss to give you a raise!

worked like a charm!...

big thank you!!!

Paul Newcome

Happy to help. 👍️