Forum Discussion

felipeprevente's avatar
felipeprevente
Copper Contributor
Sep 29, 2022
Solved

FILTER Function using a cell reference as a Boolean for the Include parameter

Hello Experts,   I've created a concatenated field to retrieve the boolean expression to be used in a FILTER function as below: A1 = "{"&B1&","&C1&","&"}" OR {1,0,1} A2 = 1   So, my formula i...
  • JMB17's avatar
    Sep 29, 2022

    felipeprevente 

     

    I usually just include a field above my table containing TRUE/FALSE to indicate which columns to include:

     

     

Resources