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.
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
This discussion was created from comments split from: Generate documents from row data.
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday
