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.
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.
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…