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.
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.
-
Thanks for the suggestion. I'll give that a try.
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