What if Blank?

[Domearian]

Hello, I run the following Filter to alter the menu I have setup. Depending on the User Type, that information will change the menu I have setup. Current User Types are Admin or Other. Below is the Filter I use:

IF(LOOKUP(USEREMAIL(), Users, Email, User Type) = “Admin”, [Type] = “Menu”, AND ([Type] = “Menu”, [Admin?] = Other))

BUT, I only want to run the above filter if the User Type isn't blank. Currently, if the user does not have any User Type or if the user is not in the datasource, they gets everything in the menu. If the User Type is Blank I don't want it to show anything.

Can I use something like IF [User Type] ISNOTBLANK (IF(LOOKUP(USEREMAIL(), Users, Email, User Type) = “Admin”, [Type] = “Menu”, AND ([Type] = “Menu”, [Admin?] = Other)))

Any help would be appreciated. 

[Steve]

SWITCH() - AppSheet Help

[Domearian]

It's not a list result I am looking for. It needs to be TRUE/FALSE.

[Steve]

What does that have to do with anything? I'll bet you didn't follow the link I provided...

[Domearian]

I did and it wasn't helpful.