Filtering columns

Hi,

We are able to filter rows using a column. Eg. I can filter to see only rows in which column B is true. But is there any way to display only column where value is true ? I would like to have full a view with full table and another view where only the select row is displayed with only columns where value is true.

A B C D E
category1 false false false false
category2 true true true true
category3 false false false true
category4 true false false false
category5 true false false false
category6 true false false false
category7 true false false false

There are probably multiple ways to do this, but I usually just create helper formula columns and then filter by those.

So in this example you would have a column called like AnyTrue? with the formula =$B == True or $C == True or $D == True or $E == True (which you can hide in views to not clutter things up) and then have a widget filter by that, if I correctly understand your request.

Hello Nick

Thanks for your answer but it still filters rows, not columns. In the example above, the goal would for example to select category7 and have a view in which you see only column where value is true.

If you select category7 you would get a view displaying:

A B
category7 true

If you select category2 you would get a view displaying:

A B C D E
category2 true true true true

The example above is simple and readable without filtering but my use case has ~200 columns.

Ah, I see what you’re after now. I can’t think of any way to conditionally/dynamically show/hide columns in a table.

I did make a little experiment to see if there was at least a way to see a filtered view of true columns with trigger formulas. This is a hacky way to do this and there are probably better methods - not sure how it would perform with 200 columns…

column-filter

1 Like