Report Filters Not Responsive

n_org

I've created a helper column in my sheet for parent/child relationships, which assigns it a number based on this formula:

=COUNT(ANCESTORS([SOW Item or Task]@row)) + IF(COUNT(CHILDREN([SOW Item or Task]@row)) > 0, "+", "")

In my report, I've created a filter to allow for all numbers except 1+:

However, the report is not showing row level 0 items, even when they match all other criteria:

In the above report screenshot, the only items showing up are level 1, 0+, and 2, but not 0.

What do I need to fix to resolve this?

Will.Parente

Hard to tell based on your images. One thing to try - change your filter on the Row Level from "Is One Of" and all the numbers to "Is Not One Of" and just choose the 1+.

This is a wild guess… but worth a try!

n_org

https://community.smartsheet.com/discussion/comment/449120#Comment_449120

Good idea, Will. It didn't work, but I've set up an alternative solution for now. Thanks for the idea!