Solved

Need help with IF formula

+4

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?

Best answer by Mike_AutomaticN

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

+28

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

+31

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!

Adam, Airtable Consultant - thetimesaving.company

+4

Thank you, I got it working!! 😃

+4

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

Than you!!!

Sign up