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:
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()
)
)
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!
Thank you, I got it working!! 😃
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!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.