New Automation Email - Conditions

[Domearian]

Hi All,  I am trying to setup an automated email when an item of data is saved. I don't usually have problems but this one just doesn't seem to be using the condition correctly.

Condition: AND([Status]="New",OR(NOT([Sub Category] = "Lost ACP"),NOT([Sub Category] = "Found ACP")))

So, if the Sub Category is either "Lost ACP" or "Found ACP" I DONT want the email to be sent but it is sitll being sent out despite the Sub Category being "Lost ACP" or "Found ACP".  Any pointers?

[Suvrutt_Gurjar]

Please try 

AND([Status]="New",NOT(OR([Sub Category] = "Lost ACP",[Sub Category] = "Found ACP")))

[Domearian]

Have made that change, I will update you if it made a difference.

[Domearian]

Unfortunately that did not work.

[AleksiAlkio · Accepted solution]

Or are you looking for? AND([Status]="New",[Sub Category] <> "Lost ACP",[Sub Category] <> "Found ACP")

[Domearian]

Tried that but the email kept coming.

[AleksiAlkio]

I would say that then the reason is something else than the formula itself. What happens if you type just FALSE?

[Domearian]

Retried this and it has worked this time. Thanks.

[Markus_Malessa]

Is [Sub Category] an EnumList maybe? If it is Text or LongText or even Enum(Text or LongText) than I have one more possibly try:

AND([Status] = "New", NOT(IN([Sub Category], {"Lost ACP","Found ACP"})))

[Domearian]

It is text, but text created from a formula. The formula does however look at Enum to decide what text to use. If the previous doesn't work then I shall try this one. Thank you.

[Steve]

Try "New" = [Status] instead of the other way around.