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.
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
