Conditional column to ignore else if first is true

[jagostinhoCT]

Hello,

I was trying to create a Conditional Colum expecting that if the first condition is TRUE than all the Else Ifs would be ignored but this does not seem to be happening.

Basically, I want to set it so that if the value on L1Tag Column equals "Transfer" then the value is set to Transfer and it stops right there.

See Conditional Statement below and resulting table.

What am I doing wrong?

Thank you

J

[simrantuli]

Hi @jagostinhoCT,

You forgot an "s" in Transfers and that's why it is not working properly for you.

I tried the same conditional column as you and it worked for me. Please find below the screenshot.

Also, I observed that you are forgetting to add a condition if the LT1Tag is not "Transfers" and the Amount is 0 i.e. the first "Else if" condition in my screenshot --> "Greater than or equal to 0". I think you should consider that also and incorporate in the column 🙂

Regards

Simran Tuli

[Greg_Deckler]

@jagostinhoCT That's exactly how conditional statements work. I think you forgot an "s" in Transfers

[Anonymous]

your column says "Transfers" not "Transfer"

Change your conditional to Contains "Transfer" or is equal to "Transfers" this will sort your issue out. 

[Fowmy · Accepted solution]

@jagostinhoCT 

Your conditions are based two fields and it will continue to evaluate the subsequent levels as based on true/false. You can add a custom column and  use OR/AND combination to achieve this as well.

It seems you have put "Transfer" instead of "Transfers", in Value section, missing last s, correct and try, it shoudl work.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[jagostinhoCT]

of course...

"Transfers" not "Transfer"

Such a rookie mistake. 😞

Sincere apologies and thank you very much.