Report Filters Not Responsive
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?
Answers
-
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!
-
Good idea, Will. It didn't work, but I've set up an alternative solution for now. Thanks for the idea!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!