Need to combine 3 fields with IF statement

Ask the Community Formulas
#1

I am sure this is easy, but I can’t figure it out on my own. I’d very much appreciate if some could point me in the right direction.

I have 3 fields: { FIRST NAME} {MIDDLE NAME} {LAST NAME}

I am looking for a formula to combine them into one field.

The names should be separated by commas in the new combined field.

I can do the above easily, BUT:

The fields are not always filled. Sometimes only one of them is filled, sometimes all 3.

So I need IF statments in combination with =BLANK()

I can do it for FIRST and MIDDLE NAME, but I can’t get the LAST NAME in…

Thank you in advance! I am lost.

#2

Hi there,

Please try to use this formula:

{FIRST}&IF({MIDDLE}," ("&{LAST}&")","")

And let us know if this worked :slight_smile: