Enum ShowIF OR

AppSheet AppSheet Q&A
1

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”

1 Like
2

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.

3 Likes