Solved: A better expression - Page 2

Nantha · 01-21-2023 06:55 PM

This expression is currently working for me,

AND(OR([Type]="External",[Type]="Overseas",[Type]="Emergency Crew"), [Status] = "Out")

I believe there's a better way to write this using the IN() or LIST() expression. I tried the below but it's not working out.

AND(IN(ANY(Loans[Type]),{'External','Overseas','Emergency Crew'}), [Status] = "Out")

Can someone help out? Just trying to learn to write better expressions.

Thank you

dbaum

Here's an expression using the functions you cite. If you didn't already, review each function's help article for details of its syntax, argument data types, and returned value data type.

Your need is a good use for IN.
ANY isn't applicable.
LIST is equivalent to your use of braces.

AND(IN([Type], LIST("External", "Overseas", "Emergency Crew")), [Status] = "Out")

View solution in original post