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
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives