SHOW IF Expression not working
I am trying to do a SHOW IF expression to show columns if they do not equal a value in a ENUM column in the table.
The expressions by themselves work with the <> value, but as soon as I wrap them together with an OR expression, they don’t work and show the column.
But, if I keep the combined expression and change the <> to = (which is the opposite of what I am trying to do), the expression works and hides the column unless either of the two values are chosen. Shouldn’t it work with the <> too?
Here is my expression with the working combined
=OR([Room/Item Name]=“Roof”, [Room/Item Name]=“Siding”)
Here is what I want it to do
=OR([Room/Item Name]<>“Roof”, [Room/Item Name]<>“Siding”)
They work like this
[Room/Item Name]<>“Siding”
but not wrapped up in OR.
Am I just missing something and my brain is not seeing it?
Thank you for any help
LinkedIn
Twitter
