# Need help with IF formula

Topic Labels: Formulas
Solved
238 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hey Airtable community,

Been hitting my head against the wall for the last hour with this. I'm trying to write a formula for:

If {Donor First Name} is not empty, then the field would read: {Donor First Name}&" "&{Donor Last Name}

And if {Donor First Name} is empty, then the field would read: {Name}

And if {Name} is empty, then the field would just remain blank.

Here is my stab at the formula, which I am getting an error message for:

Any ideas how to make it work?

1 Solution

Accepted Solutions
6 - Interface Innovator

Hey! Do you mean Name, or People (as shown in formula?). In any case, try this formula:

IF(
{Donor First Name},
{Donor First Name} & " " & {Donor Last Name},
IF(
{Name},
{Name},
BLANK()
)
)

4 Replies 4
6 - Interface Innovator

Hey! Do you mean Name, or People (as shown in formula?). In any case, try this formula:

IF(
{Donor First Name},
{Donor First Name} & " " & {Donor Last Name},
IF(
{Name},
{Name},
BLANK()
)
)

18 - Pluto

Your formula works fine, you've just got some issues with the parentheses.  Try this:

``````IF(
NOT({Donor First Name} = ""),
{Donor First Name} & " " & {Donor Last Name},
IF(
{Donor First Name} = "",
Name,
""
)
)``````