Sort based on last name
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?
Answers
-
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))
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!