I have multiple columns with true/false logic, how do I show all the trues for the columns?

[jkingcrow21]

Need to display only the trues for the computation columns, however, I have 25+ columns with true/false statements

[Akshay1 · Accepted solution]

Yeah a compute statement that goes like 

If(And(@Col1@ = true,@Col2@ =true,@Col3@ = true),true,false)

Note: this is is an example with just three columns as true, in your case we would need to apply this formula going all the way to the 25th column that should be true.

Thank You,
Akshay

[jkingcrow21]

I want to keep all the rows where the columns are true. So I cannot filter the columns, but maybe a computation would work?

[Akshay1]

Hello Jkingcrow21 - Do you only want to keep row values where all values across all the 25 + columns that are true or do you want to filter this based on One particular column.

Thank You,
Akshay