Name instead email on System/Created By column

Al ISS

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.

Al

 

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.

Al

 

 

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.