felipeprevente
Sep 29, 2022Copper Contributor
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 is: FILTER(FILTER(GroupAuth!D:F,GroupAuth!A:A=A2),A1) OR, Filter/Retrieve the columns from D to F, where the value at the row level in column A = 1, retrieving only the first and third columns.
Is it possible to use a cell reference instead of writing the boolean in the "Include" parameter? If it's not, does anybody knows a workaround?
Thanks in advance!
Felipe
I usually just include a field above my table containing TRUE/FALSE to indicate which columns to include: