IF function with an enum

AppSheet AppSheet Q&A
1

Hi,

I think I have a relatively simple question. However, I cant find it on the forum. I want normally have an Enum which has the options 0, 1, 2, 3. When I have a 0 I want to show nothing. However if it is higher than 0, I want a column to pop up.

opdemonchy_0-1661938281459.png

Above you see the 2 columns

I have this function now

opdemonchy_1-1661938433444.png
opdemonchy_1-1661938433444.png654×416 26.8 KB

So I put in SHOW IF = [Enum_name] = 1, [Enum_name] = 2, [Enum_name] = 3,
However, it does not work.

Can someone help me.

Thanks a lot!

2

Here’s the necessary syntax for using the OR function:

OR([Foot] = 1, [Foot] = 2, [Foot] = 3)

In case it’s helpful, an alternative is the IN function:

IN([Foot], LIST("1", "2", "3"))

Also, consider whether your app design would benefit from using a Number type column instead of an Enum type. That column type accepts only integers, and you can set the minimum and maximum values. That can then facilitate expressions like:

AND([Foot]>=1, [Foot]<=3)

You could probably even get away with this type of expression without changing the data type since there are ways to convert numeral characters to numeric values.

3 Likes