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

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.