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!
Solved! Go to Solution.
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!
Hi @kiwipops ,
You can use the following formula.
if contains([Field1],'word') then 'yes'
else null()
endif
Best,
Fernando Vizcaino
Thank you--that did the trick! I knew it would be more simple than what I was attempting to use, ha! 🙂