How to set a column true if parent row
I need to set a helper column with a value for parent rows so I can use those rows in a report.
I have tried the Parent() function, but I dont think its exactly what I need. Not really understanding what it returns.
In the report I need to filter out children and show only parent rows.
Can someone give a hand?
Thanks
Pam
Answers
-
If you only want to show parent rows, in your "Helper Column" add the below formula to every cell.
=COUNT(CHILDREN())
All of the parent rows will have a number greater than 1, the children rows will have a value of 0, as in the below Sheet screenshot.
In the Report Builder, make your WHAT criteria "Helper Column" is greater than 0. This will allow only the Parent rows to come in.
You could also spruce it up a little bit by using a checkbox or symbols to classify rows, for example I'm using the Yes/No/Hold symbols below to display "Yes" if the row is a Parent and "No" otherwise.
Formula for the below is
=IF(COUNT(CHILDREN()) > 0, "Yes", "No")
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
-
Excellent idea! Thank you so much!
-
Worked for me, too. Thanks.
Help Article Resources
Categories
Check out the Formula Handbook template!