Combine columns using formula tools

[micou]

Hello all, 

I wanted to use a formula to combine the data.

if column A = orange, combine column B and C

otherwise, leave it as Column B.

I used

IF contains ("orange",[Column A])

Then [Column B] + "," + [Column C]

Else [Column B]

Endif

but it was not working. just wondering how i can fix this.

Thank you!!!

[deviseetharaman · Accepted solution]

Hi @micou 

Is this what you are looking for