Best way to truncate people's names (to first name, last Initial)
We have several dashboards /sheets that have people assigned to tasks, sometimes more than one. When the names get long, it can make it hard to fit within the format we're looking for. Wrapping text will increase the row width, while not wrapping means the column has to be very wide.
Question: What's the best way to change format to First Name, Last initial? When I add the name to "My Smartsheet Contacts" I now see everyone's name listed twice and the "Account Contact List" is always on top and becomes the default selection.
Is the only/best way to do this is to have the Admin truncate the names in the "Account Contact List" for me?
Thanks!
Answers
-
Hello @miwalker -
If you have a contact list or people's names column, then add another column and try the following formula -
=IFERROR(LEFT([First Name]@row, FIND(" ", [First Name]@row) - 1), [First Name]@row
and see if this helps
Cheers,
Ipshita
Ipshita Mukherjee
-
Thank you... I'll give this a shot!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives