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

[dkals]

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. 

[Sistema_Aotearo · Accepted solution]

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.

[dkals]

That worked, thank you so much!!