I have a book database and I am splitting the Author name into Author First and Author Last columns.
The problem I run into is certain books are authored by a company. I don’t want to split the company name up. Is there a way to identify an company name and then place it in the last name column of the split formula.
Something like this:
If Name is Company x than place in last name column If Name is not Company x than place text before space into last name column.
Just an idea/thought, but one solution would be to have 3 fields: 1. Author First Name, 2. Author Last Name, and 3. Company Name
Then a 4th formula field ‘Author’ (for example) which would pull the author’s first and last name (fields 1 & 2 above) OR the Company name (field 3 above) depending on which was blank. That way, you can have a single ‘Author’ column to sort or filter data as needed. and Fields 1-3 would be your inputs.
You could make the primary field the formula I mentioned, which would combine the full author name or show the company name?
Not sure I follow your last comment but something like this: