Sort based on last name

topazfae

I know this is a SIMPLE question, but I couldn't figure out how to do that. I have a column that consists of contacts, but I want to sort it based on the last name, not their first name. How would I do that?

Eric Law

https://community.smartsheet.com/discussion/114415/sort-based-on-last-name

You will need to create a column that has last name and grab the last name of the name column then sort. Here is a formula for you to use in your last name column. It basically grabs the "words" after a space. This will only work if the names do not have multiple parts to it, such as John Doe will return Doe, but John W. Doe will return W. Doe. Hope that helps!

=RIGHT([Name]@row, LEN([Name]@row) - FIND(" ", [Name]@row))

topazfae

Rats - I have multiple last names. I wish there was an easy way to do that. I will set up a helper column and use that for last name and hide it when I'm not using it.