So I’m trying to create a fairly complex filter and I’ve run into a wall. I have a list of rows, found like this:
BigList.filter(thisRow.column = column)
It gets all of the rows that have the same value in the same column. I now want to remove all of the values from this view with the filter. It’s a part of an if statement, so I can’t leave it as is and have it filter. I’ve seen the code for the default filter formulas set the row as = -1, but that just seems to remove some of the options (the first I think). FormulaMap doesn’t seem to work either.
If it helps I can share the entire formula and my ultimate goal, but the rest of the filter seems to work.