Reports with 3 levels of filter groups?

Natalia Kataoka · 03/02/22

Not sure this is possible, but I am looking to create a report that has 3 levels of filter groups, as in the screenshot below. If it is possible, how do I achieve it?

Paul Newcome · 03/04/22

I suggest something like a hidden checkbox column on the source sheet to (using a formula) check the box on rows that meet the OR/AND portion.

=IF(Complete@row = "", IF(OR([Date Finish]@row< TODAY(), Status@row = "specific text"), 1))

Then you can set up your report filter so that you have your task name "or" grouping as well as the hidden box being checked.

Kayla K · 02/23/24

Is there no other way to get a 4th level of filter groups? My situation is almost identical but I don't own the source sheet and cannot add a column to it.

Thanks for any advice!

Paul Newcome · 02/23/24

@Kayla K Your only option would be to convince the source sheet owner to add a column for you.

Kayla K · 02/23/24

I found a way to restack them!

Not sure if this helps others but I wanted to leave it here just in case.

Vertex_DanielL · 03/14/24

https://community.smartsheet.com/discussion/comment/421621#Comment_421621

Can you explain the steps to do this? I am struggling with trying to get a third level in here. Everything I do just makes new 2nd levels or adds to existing 2nd levels. I am stumped.

Vertex_DanielL · 03/14/24

Found another post with what I assume is a workaround rather than a feature as-designed: https://community.smartsheet.com/discussion/comment/385066/#Comment_385066

Worked for me!

Reports with 3 levels of filter groups?

Answers

Categories