If/Then statement - help!

[kiwipops]

First time poster here, so pardon if I've missed any posting guidance. 🙂

I am trying to get all instances of "word" from one column to output "YES" into another column (I've looked around for alternatives, but having a hard time find a solution that fits my format!).

If column [A] contains "word", then I need the word "yes" to output into column [B]. I've tried a few variations of if/then statements, but I'm just getting null results.

Thanks in advance!

[fmvizcaino]

Hi @kiwipops ,

Take a look at my example and see if that works for you.

Best,

Fernando Vizcaino

[kiwipops]

This is close--I realized I worded my ask wrong (sorry!). It should be if in Column A contains "x/word" (so pulling out keywords from the field vs. a direct match). Could I tailor your formula that way?

Thanks again!

[fmvizcaino · Accepted solution]

Hi @kiwipops ,

You can use the following formula.

if contains([Field1],'word') then 'yes'
else null()
endif

Best,

Fernando Vizcaino

[kiwipops]

Thank you--that did the trick! I knew it would be more simple than what I was attempting to use, ha! 🙂