Something I’ve noticed about filter/visibility conditions on lookup columns:
Relation columns relate two sheets based on matching criteria within rows of selected columns from each. Then lookup columns lookup data from one column of that relation. If that lookup column is a Template or If-Then-Else column, any empty rows of data from any instances of that lookup column will NOT be recognized as empty. They will be recognized as empty placeholders… which the visibility/filter conditions do not recognize as empty. So using a Template or If-Then-Else column to create conditions of visibility or filtering will not work. On the other hand, if the lookup column is just a regular sheet column, any empty rows will be empty and you can create all sorts of powerful conditions using lookup columns.
The problem, of course, is that using sheets columns for lookup columns adds a lag to your conditions since you have to wait for your sheet to update. I’ve noticed this for a while. Anyone else?