Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 05, 2024 02:30 PM
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:
Solved! Go to Solution.
Sep 05, 2024 06:31 PM
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()
)
)
Sep 05, 2024 06:31 PM
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()
)
)
Sep 05, 2024 09:16 PM
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!
Sep 06, 2024 09:04 AM
Thank you, I got it working!! 😃
Sep 06, 2024 09:05 AM
Than you!!!