Formula Help!

Hello! I need some help. I’ve tried to use the AI formula generator but I can’t get this formula to work. My goal is taking column 1 ‘Name’ which either has First + Last Name or First Name only. My goal is to extract the first name into a new column ‘First Name’. When there is a space between first and last name, I want the text before the space. When there is no space and therefore no last name I want everything within that first column. Ex: If column ‘Name’ = Jane Doe, I want the new column ‘First Name’ to populate Jane. If column ‘Name’ = Jane, I want the new column to pull Jane. Below is the formula which works for Jane Doe examples but not the Jane examples. All first name only entries show a (!) error in the formula column.

IF(SEARCH(" “, {Name}) > 0, LEFT({Name}, SEARCH(” ", {Name}) - 1), {Name})

Thank you!

Hi Shannon! Could you give this formula a try? I’ve tweaked it a bit from the one you shared, and it worked when I tested it out. Let me know :slight_smile:

IF(SEARCH(" ",{Name})>0,LEFT({Name},SEARCH(" ",{Name})),{Name})

Hi Shannon,

You can use AI to extract this directly into a text column :slight_smile:

If you create a text column, then use the AI option in the menu to extract either the first or last name (added a screenshot)

This will only work on newly created items though (for some reason), so you might need to create it on another board, and then move the items to it.

Hope that helps

Yes!! You did it. Thank you so much :slight_smile: