Name instead email on System/Created By column

Al ISS · 01/25/18

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 · 01/26/18

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 · 01/26/18

Shaine,

Thank you for your answer.

Al

J. Craig Williams · 08/31/18

I submitted this request too.

Craig

Melissa Wells · 10/04/18

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.

Name instead email on System/Created By column

Comments

Categories