Blank field or not

[Julien_Etoke]

Hello!

My table is the first step to generate documents with personalized names. Sometime there is 1 name on the document, sometime 2.

List of my columns :

Name 1
Name 2

Name 2 + and (formula)

I'm trying to find the good way to write the formula of my name 2 + and column :

Option 1 : there is a second name and I need « and name 2 »

Option 2 : there is no second name and I need a blank field

At the moment, if I have no « name 2 » I still see « and » in all my fields 🙂

There is my work/try :

CONCATENATE({And}, " ", {Name 2}) (it works fine)

IF({Name 2} = BLANK() => don't show "and" in this column.

Can you help me fo write this formula please ?

Thanks for your reading!

Have a nice day.

[Chris_Luc]

Hey Julien, here's the formula:

IF(

    {Name 2},

    {Name 1} & " and " & {Name 2},

    {Name 1}

)