Sign in to join the conversation:
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
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
Shaine,
Thank you for your answer.
I submitted this request too.
Craig
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.
This discussion was created from comments split from: I am an editor on a smartsheet but can't edit the sheet.
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…
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…
