Help

Empty / blank formula

Topic Labels: Formulas
Solved
Jump to Solution
1577 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

Hello!

I'm making a table to generate contracts. Sometime there is 1 name on the contract, sometime 2.

List of my columns :
Name 1
Name 2
And (just a formula for write "and" in the column).

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

CONCATENATE({And}, " ", {Name 2}) (it works fine)
IF({Name 2} = BLANK() => don't show "and" in this column.

Thanks for your reading!

Have a nice day.


2 Solutions

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

You want to put the word " and " between the two names, if there are two names?

If either name could be present, eg. {Name 2} without a {Name 1}.

CONCATENATE(
  {Name 1},
  IF( AND({Name 1}, {Name 2}), " and "),
  {Name 2}
)

 

If {Name 2} only appears if there is also a {Name 1}

 

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

 

 

See Solution in Thread

Not really, I wants to show the word "and" in my formula only if the field "name 2" is notblank 🙂

 

That's what my formulas do. Did you try them? If they do not give the results you want, could you send screen shots?

See Solution in Thread

5 Replies 5
kuovonne
18 - Pluto
18 - Pluto

You want to put the word " and " between the two names, if there are two names?

If either name could be present, eg. {Name 2} without a {Name 1}.

CONCATENATE(
  {Name 1},
  IF( AND({Name 1}, {Name 2}), " and "),
  {Name 2}
)

 

If {Name 2} only appears if there is also a {Name 1}

 

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

 

 

Not really, I wants to show the word "and" in my formula only if the field "name 2" is not blank 🙂

Julien_Etoke
6 - Interface Innovator
6 - Interface Innovator

I know i'm close !

=IF(OR({Name 2}=BLANK(),CONCATENATE({Name 2},{And}),CONCATENATE({Name 2},", ",{And}))

Any idea @kuovonne ? 🙂

Not really, I wants to show the word "and" in my formula only if the field "name 2" is notblank 🙂

 

That's what my formulas do. Did you try them? If they do not give the results you want, could you send screen shots?

 

Hello!

It works, I do not know how I managed but I did not get the right result by testing the first time!

Thanks a LOT 🙂