How to group child rows when creating a report?
I have a sheet where the a person is in one column and the projects that he's assigned to are in the next column called "Projects".
I am trying to create a report to measure the allocation% percentage a person has for each project by month.
To do this I placed all of the projects that each person is assigned to in Children Rows, hence the minimize button in the "Person" row.
The problem I'm running into is that when I create a report and try to group by "Person" it is grouped wrong because it's not counting the "Project" column as a Child. So the blank spaces in the "Person" column is also being counted as a group.
Anyway to solve this? I saw similar threads and it was suggested to create "Helper" columns. Not sure how to use them in this case.
Best Answer
-
Hi @mbsamuel6
I would also suggest creating a "helper" column! I would create a column in your source sheet (that can be hidden) with a column formula applied. The formula would be really simple PARENT formula, like so:
=PARENT(Person@row)
This will bring the name of that top row into all the Child Rows. You can then Filter by this column in your Report to get rid of the top rows, and Group by this helper column as well.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @mbsamuel6
I would also suggest creating a "helper" column! I would create a column in your source sheet (that can be hidden) with a column formula applied. The formula would be really simple PARENT formula, like so:
=PARENT(Person@row)
This will bring the name of that top row into all the Child Rows. You can then Filter by this column in your Report to get rid of the top rows, and Group by this helper column as well.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you so much Genevieve. I knew I needed the helper column just wasn't sure what formula to use.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives