Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

# Re: Empty / blank formula

Solved
Jump to Solution
1073 0
cancel
Showing results for
Search instead for
Did you mean:
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
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})
)``````

18 - Pluto

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?

5 Replies 5
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})
)``````

6 - Interface Innovator

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

6 - Interface Innovator

I know i'm close !

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

Any idea @kuovonne ? 🙂

18 - Pluto

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?

6 - Interface Innovator

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 🙂