Archived 2017 Posts
Archived 2017 Posts
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
