I have three lists all in one hierarchy (L1, L2, and L3). How can I set up a filter using booleans to allow users to select which level of the list they want to see? L1 is parent of L2, and L2 is parent of L3. I'm trying to replicate the functionality of "Select Levels to Show" so that I can set the filter on multiple grids. Since there are three different grids on the dashboard that I would use this on, it's less work to check this one filter than Select Levels on all three grids each time they use the dashboard.
I also want to know how to solve this issue.
I tried various methods in Summary: Formula, but failed.
I think that this problem can not be solved by not having common variables in multiple Lists with parent-child hierarchies.
If anyone can solve it, I would like you to post it here!
Take at look at these
They might help you for your use case