A better expression

AppSheet AppSheet Q&A
,
1

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

2

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")
2 Likes
3

Perfect! I did tried to go through the articles but just couldn’t figure out where i was going wrong. Thank you so much for taking the time to help out. Much appreciated!

1 Like