Keep Parent and children rows together

I have a list of locations that each have children rows with different services, i want to filter and sort by the parent row and keep the children underneath each parent.
For example if i want to sort by state, county responsibility etc
Best Answers
-
To filter you would need to insert a helper column (or multiple depending on what you are filtering on) that uses a formula to pull the parent row data onto each of the child rows and then filter based on these helper columns.
-
Hi @Max Ahmed
Check out this other Community post: Way to tell a report to include the parent row info for child tasks?
It has a screen captures and example formula.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
Sorting should not move the child rows from underneath their parent rows. It should sort the parent rows and then sort the child rows within their established grouping.
-
Right, But the child rows have different values. thus they do not show up under the parent. For example if i try to sort by NY (in the parent) the children do not show up underneath.
-
Filtering, If I want to see only locations in say NJ i would filter for Nj, but none of the children come with it. Instead I only see the parent with no dropdown.
-
To filter you would need to insert a helper column (or multiple depending on what you are filtering on) that uses a formula to pull the parent row data onto each of the child rows and then filter based on these helper columns.
-
I see. Thank you. What would be the best way to do so? Is there a guide on this issue?
-
Hi @Max Ahmed
Check out this other Community post: Way to tell a report to include the parent row info for child tasks?
It has a screen captures and example formula.
Cheers!
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions