How do I extract only the Last Name from a USER name?

To do this:

• Create a new Formula - Text field
• Put in the following formula: Trim(Part(UserToName([Quickbase User]),2," "))

Where [Quickbase User] is the field where your Quickbase user is.

UserToName would convert the Quickbase user to the <First Name> <Last Name> 
Part would get the second part of the name on the <space> delimiter, which results in the last name. 

Now you can use that value to compare it with any other field.

------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------