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.
