Multi-Field Formula If statement

[LizB]

Hi, I'm hoping to create a formula to read across multiple fields. If the fields contains a certain string, I would like to output just 1 filed with that string. For example in the below dataset, just output 'Red':

I tried the following multi-field formula, but it outputs multiple fields, when I just want one. Any input would be great!

if contains([_CurrentField_],'Red') then [_CurrentField_] else null() endif

[Qiu]

@LizB 
I think you are correct, the MultiField tool may not be fit here.

Can we try something else?

[fmvizcaino]

Hi @LizB ,

I think there is no direct way of doing it, so here a suggested workflow for what you need to achieve.

Best,

Fernando Vizcaino

[LizB]

Thank you, this works!