- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 12:50 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 04:50 PM
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.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 04:50 PM
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.
Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 09, 2024 04:58 PM
That worked, thank you so much!!
