Need help with IF formula

[shelby_jackson]

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?

[Mike_AutomaticN · Accepted solution]

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()
)
)

[TheTimeSavingCo]

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,
    ""
  )
)

Link to base

Check out Mike's answer to see how your formula can be simplified though!

[shelby_jackson]

Thank you, I got it working!! 😃

[shelby_jackson]

Than you!!!