Solved: Help needed for a Nested Expression "AND, IF ... - Page 2

Atlas · 09-21-2022 08:57 AM

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

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"})
)

View solution in original post

Help needed for a Nested Expression &quot;AND, IF LOOKUP, OR&quot;

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