How to get a report or list of items that have subtasks (children) but including the parent row?
Hi SS team,
I'm using the card view to synthesized a large data set in a sheet. In the card view, It will reflect what is parent task they're assigned to. I need that information in a report.
The problem I'm having is that in any report that I create it will bring the other rows that are not linked to the child row.
For example:
"Parent 0, Child 1", the report will bring all other rows with "0" in the hierarchy relationship.
Card View will reflect in small letters on top of the card the Parent task and the sub-task that is linked to. I need to extract this information, how?? Please.
Answers
-
I would suggest a checkbox column in the sheet that has a formula to check off the child rows if they meet the report criteria. You can then use a formula to check off the parent row if any child row is checked and have the report pull based on this column.
-
Hi Paul,
What is the formula you're suggesting that will help me identify the parent attached to the child row?
-
Thanks for your help
-
The formula for the parent rows could be something along the lines of...
=IF(COUNTIFS(CHILDREN()), 1) > 0, 1)
The formula in the child rows could vary depending on your criteria.
-
Thanks so much Paul,
I'll try this one.
-
You could simplify this down to a single formula that could be made into a column formula and therefore applied to all cells in the column that's even smaller.
=count(parent())
Note: this will also check single lines that aren't children, which could be a positive or negative.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives