Hi,
I am trying to get certain columns in my table to SHOWIF certain options are chosen from a previous column ENUM. I have been able to figure out how to get the columns to SHOWIF there is “Option 1” selected from the ENUM but the problem I am having is being able to SHOWIF there is “Option 1” OR “Option 2” is selected from the ENUM column.
I want the column to be able to show if the user selects “Option 1” or “Option 2” from the ENUM column.
[Enum Column] = “Option 1” works but essentially I want to be able to…
[Enum Column]= “Option 1” OR “Option 2”
Solved! Go to Solution.
There’s a couple of different ways you can tackle this:
Or(
[Enum Column] = “Option 1”,
[Enum Column] = “Option 2”
)
Or…
In([Enum Column], list( “Option 1”, “Option 2”))
As a matter of reference, the IN() function will process faster.
There’s a couple of different ways you can tackle this:
Or(
[Enum Column] = “Option 1”,
[Enum Column] = “Option 2”
)
Or…
In([Enum Column], list( “Option 1”, “Option 2”))
As a matter of reference, the IN() function will process faster.
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |