Removing child rows who don't fit my criteria in a report.
![Ryan P Anderson](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have a sheet where the parent row's "processed" column is not check-marked, but the child rows indented is check-marked. I need my report I created from it to show just the parent rows, but it always includes all "processed" child rows. Is there a way to just show parent rows?
Answers
-
When I'm dealing with hierarchy and Parents/Child rows, I always like to add an hidden helper column named Rank.
In this column put this formula:
=COUNT(ANCESTORS())+1
It will display a number 1 for every parent row that you have, and 2 or more for every children.
Then, in your report, select the option to display lines with Rank=1, and thus only parents rows will appear.
-
Yes, there is.
Is there anything in the Parent rows that are always the same? We could use that as a criterion.
Another way, and that is the way I usually do it in my client solutions.
Have a so-called helper column that indicates what level the row is on, and that can be used as criteria only to include the parent rows.
Something like this. (all children rows will not have a level in my example.
=IF(COUNT(CHILDREN([Task Name]@row)) > 0; COUNT(ANCESTORS()) + 1)
Make sense?
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
The child rows all have a specific column checkmarked that the parent ones do not. I used this in my report specifications but it still showed up. Would using a number as my consistent identifier help?
-
Are you using the OR option or the AND option in the Report builder?
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
As I was sending you screenshots I realized my mistake, I appreciate your time though :)
-
Excellent!
Glad you got it working! What was the issue?
You're more than welcome!
✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
I forgot I added other 'or' options in my report builder that the child ones fit.
-
Easy to miss!
✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives