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!

Find more posts tagged with

Reports

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.