Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Need help with IF formula

Topic Labels: Formulas
Solved
Jump to Solution
387 4
cancel
Showing results for 
Search instead for 
Did you mean: 
shelby_jackson
5 - Automation Enthusiast
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:

Screen Shot 2024-09-05 at 2.29.10 PM.png
 
Any ideas how to make it work?

 

1 Solution

Accepted Solutions
Mike_AutomaticN
7 - App Architect
7 - App Architect

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

See Solution in Thread

4 Replies 4
Mike_AutomaticN
7 - App Architect
7 - App Architect

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

Screenshot 2024-09-06 at 12.15.26 PM.png

Link to base

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

shelby_jackson
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you, I got it working!! 😃

Than you!!!