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
