Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Report - shows only parent projects (or tasks)
Hello everyone,
So far, I'm pleased with an interaction in this community - I get responses quickly. I really appreciate!
In reporting, I'd like to show only parent projects (or parent tasks), not showing sub items. How do I select parents?
Thank you!
Yoko
Comments
-
One way that I accomplished this was to create a column with an identifier for the parent rows only. Then when I created the report I only pulled rows that contained the identifier.
-
I agree with Mike. I would create a column with a flag to denote "parent" I use the following formula:
=IF(COUNT(CHILDREN(Column:Column)) > 0, 1,0)
-
Mike and Marcus, thanks! I guess that the product does not have such a function - sad to know.
Yoko
-
ysuzuki,
If you need something like this, please write an enhancement request using the link to the right on this page.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives