Help needed for a Nested Expression "AND, IF LOOKUP, OR"

[Atlas]

Trying to make an expression for only if this condition true section in Action Behaviors. After adding the code below, I can't use the actions. Seem like a magic touch needs, to simplify and rearrange this expression.

Thanks for the help.

AND(
IF(
LOOKUP(USEREMAIL(), “STAFF”, “E-MAIL”, “FUNCTION” )="APPROVE",TRUE,FALSE),
OR(
[Status]="waiting",
[Status]="cancel")

[WillowMobileSys · Accepted solution]

It doesn't appear you have complete syntax in what was posted and YES it can be simplified to:

AND(
    LOOKUP(USEREMAIL(), “STAFF”, “E-MAIL”, “FUNCTION”) = "APPROVE",
    IN([Status], {"waiting","cancel"})
)

[Atlas]

Thank you so much for the simplified version. I learn a lot from your replies. By the way, when the both expression didn’t worked out. I began to explore where would be the problem is. Then  I realized that,  on click selection for the actions in card view was empty. I selected the action for click on and I can use it now 🙂