Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Blank field or not

Topic Labels: Formulas
680 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}
)