The scenario:
Our project management database "Projects" has parent/sub-items that are also projects. Status options include active, planned, and complete.
We do a lot of grant funded work and we have a general system of a "master project" for each grant and sub-projects for both the required reports and the work of the grant. This broadly works for us.
I had set up a view that only shows grant reports, grouped status and ordered by due date. This view was really helpful before we set up the parent/sub items on the database. It was a very clear view of all of our reports. After we added the "parent/sub" option, however, the reports are being grouped by the status of the parent project. So a report due May 2027 that should be shown as "Planned" which is the status of the individual project, is instead grouped under a master project and shown as "Active".
How do I create a view that ignores the parent projects?
