Hi! Is there a way for me to pull only the parent details in my report without having the subtasks?
Hello!
I am trying to create a report and pull only the parent task details- is there a way to do that? could you help me with a formula?
Answers
-
You could add a helper column (that you can hide and ignore) with a column formula that counts the number of children
=COUNT(CHILDREN())
Then in your report filter on only those where the count of children is greater than 0.
-
Thank you - is there a way I can pull this to another report with the same formula linking the sheets?
-
I'm not sure I understand the question. The formula needs to go into the sheet (or sheets). You can use the result of the formula to filter your report.
In the report click on filter and set it up like this, where "New Column" is the column that contains the formula =COUNT(CHILDREN()).
This will include only the parent rows in the report.
-
Thank you :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!