+5Hello!
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 :
Thanks for your reading!
Have a nice day.
Best answer by kuovonne
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})
)
+29You 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})
)
+5You 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 🙂
+5I know i'm close !
=IF(OR({Name 2}=BLANK(),CONCATENATE({Name 2},{And}),CONCATENATE({Name 2},", ",{And}))
Any idea @kuovonne ? 🙂
+29Not really, I wants to show the word "and" in my formula only if the field "name 2" is not blank 🙂
> 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> 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 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.