Report: Show me child tasks ONLY if the parent is In-Progress
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!
Best Answer
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Paul, you're a genius! Tell your boss to give you a raise!
worked like a charm!...
big thank you!!!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!