Hi! I'm trying to create a formula for the following columns:
1: First Name
2: Last Name
3: Pen Name
where If "Pen Name" is blank, use "First Name + Last Name". I keep getting stuck somewhere and getting invalid formula errors.
Solved
If 1 column is blank, pull in text from others.
+4Best answer by Sistema_Aotearo
Use this formula. Let me know if this works!
{Pen Name} &
IF(
{Pen Name}="",
{First Name} & " " & {Last Name})
I do similar set-up where they might have a preferred first name. In my case I swap only the first name and always include the last name. I do this by taking the last parenthesis and place just after {First Name}.
I've adjusted the formula to match what I believe you're asking for. Where it uses both First and Last names if Pen Name is blank.
+20Use this formula. Let me know if this works!
{Pen Name} &
IF(
{Pen Name}="",
{First Name} & " " & {Last Name})
I do similar set-up where they might have a preferred first name. In my case I swap only the first name and always include the last name. I do this by taking the last parenthesis and place just after {First Name}.
I've adjusted the formula to match what I believe you're asking for. Where it uses both First and Last names if Pen Name is blank.
+4Use this formula. Let me know if this works!
{Pen Name} &
IF(
{Pen Name}="",
{First Name} & " " & {Last Name})
I do similar set-up where they might have a preferred first name. In my case I swap only the first name and always include the last name. I do this by taking the last parenthesis and place just after {First Name}.
I've adjusted the formula to match what I believe you're asking for. Where it uses both First and Last names if Pen Name is blank.
That worked, thank you so much!!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.