Welcome!

Name instead email on System/Created By column

Hi,

Any suggestion how I can have the name instead email when I have a System column and choose "create by" option from my contact list?

Thanks.

Find more posts tagged with

Contacts

Comments

Shaine Greenwood

Hi Al,

There currently isn't a way to customize the display of the System (Created by) column.

When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right to let our Product team know that you'd like to have this feature added.

As a potential workaround, you can create an additional Text/Number column, and place a nested IF statement that will return people's names when their email appears in the system column. For example:

=IF([System Column]1 = "john.smith@gmail.com", "John Smith", IF([System Column]1 = "jane.doe@gmail.com", "Jane Doe"))

More on IF statements can be found in the help center: https://help.smartsheet.com/function/if

Al ISS

Shaine,

Thank you for your answer.

J. Craig Williams

I submitted this request too.

Craig

Melissa Wells

Hi Shaine ...

Would you help me please with an IF formula that does the same as you list above but with 5 contacts?

I'm having a hard time writing a Nested IF statement for more than two options.

Thanks for your help.

Sign in to join the conversation!

Quick Links

Trending discussions

Sharing with Editors outside our company
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
Can an admin of a sheet be from a different organization?
I have shared sheets and dashboards with people outside of my organization, and one has a paid license. Would I be able to grant admin access to this licensed user to their sheet? Or would the ownership of the space by one organization limit the admin accessibility of someone from outside?
How to create stack column graph bars
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…