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?
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 = "[email protected]", "John Smith", IF([System Column]1 = "[email protected]", "Jane Doe"))
More on IF statements can be found in the help center: https://help.smartsheet.com/function/if
Thank you for your answer.
I submitted this request too.
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.
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.