With FILTER you can remove certain elements from a list.
FILTER
FILTER([true, true, false], true)
This filters out all the true values in the list evaluating to [false].
true
[false]
FILTER([1, 4, 2, 1, 3, 1, 4], 4)
This removes 4 from the list evaluating to [1, 2, 1, 3, 1].
4
[1, 2, 1, 3, 1]
Last updated 7 months ago
Was this helpful?