Edit name in assigned to column
Sarah E
✭
I'd like the assigned to column to simply show the initials of the contacts assigned, as opposed to the full name and email. Is there a way to configure this in Smartsheet?
Answers
-
You could create another column next to it using the formula below to obtain just the initials from the contact if available.
If there is no name and just has an email it will just return blank. If you have an idea of what you want for the case of emails just let me know.
Be sure to replace the "contact" with your contact column.
=IF(FIND("@", contact@row) > 0, "", LEFT(contact@row, 1) + MID(contact@row, FIND(" ", contact@row) + 1, 1))
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives