SHOW IF on an Action

AppSheet AppSheet Q&A
1

Hello, all. I have an action called “Close Work Order” that sets the [Work Order Status] column to “Closed.” I don’t want the action to be available if the value of the [Task Code] column is either “MILLING” or “TRAINING.” I tried this expression but it does not work; action still shows up:

OR(
[Task Code]<>“MILLING”,
[Task Code]<>“TRAINING”)

When I use just one of the expressions - for instance [Task Code]<>“TRAINING” - the action’s availability behaves as it should. I’m almost certain the fault is in the logic of the expression but since I’m drinking decaf coffee today, I can’t see it.

Any help is appreciated. Thanks!

2

>>“I’m almost certain the fault is in the logic of the expression”

You’re right.

In order for your expression to turn FALSE, your [Task Code] would have to be equal to both “Milling” and “Training”, which is impossible because nothing can be equal to more than 1 value.

You probably just want to change OR to AND.

1 Like
3

Marc, thanks for guidance! It got me on the right path. I changed it to the following and it seems to work:

IF(
OR
([Task Code]=“Milling”,
[Task Code]=“Training”),
FALSE, TRUE)

There’s probably other ways to do this but this did the trick. Thank you!

1 Like