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
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives