Report not sorting by Contact column

I have a report that pulls data from about 50 sheets. I need to sort the report alphabetically by the Name Column, which is a formatted as a Contact Colum.
It sorts by email address and not by name.
For example:
Anthony Smith with an email address of TSmith@email.com sorts in by the T and not the A.
Is there a setting I am missing?
Thanks!
Best Answer
-
Hi @Yvette Moreland,
You should create a helper column "Display Name" that formatted as a Text/Number column, with a formula to get display name from the "Name" column :
=Name@row
Now in the report, you can sort by "Display Name" column.
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech
Answers
-
Hi @Yvette Moreland,
You should create a helper column "Display Name" that formatted as a Text/Number column, with a formula to get display name from the "Name" column :
=Name@row
Now in the report, you can sort by "Display Name" column.
Hope that helps.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech -
Thanks for the suggestion. I'll give that a try.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives