Help

Blank field or not

Topic Labels: Formulas
338 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

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.

1 Reply 1
Chris_Luc
6 - Interface Innovator
6 - Interface Innovator

Hey Julien, here's the formula:

IF(
    {Name 2},
    {Name 1} & " and " & {Name 2},
    {Name 1}
)