Help

If 1 column is blank, pull in text from others.

Topic Labels: Formulas
Solved
Jump to Solution
176 2
cancel
Showing results for 
Search instead for 
Did you mean: 
dkals
4 - Data Explorer
4 - Data Explorer

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. 

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.

That worked, thank you so much!!