Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
I don't understand why you don't see the name of the collaborator and just show your email. What remains to be done so that it looks the same as the rest?
See images please. Thanks
Are they users on your account? If so I'd try setting their names in the user management that can be accessed from you account admin's screen.
The other possibility I can think of is updating their contact info in your Smartsheet contacts. Double-click on the emails and edit their names or go to the upper right hand corner to My Smartsheet Contacts.
I hope this helps!
Hi Gerardo,
More info about Contacts: https://help.smartsheet.com/learning-track/get-started/contacts
If you're using formulas in contact fields, it could be because of a flaw in the logic. (see below for more info)
Barry Bowles
August 17, 2019 8:58 pm
Shaine this is a great new feature to Smartsheet- THANK YOU! - it seems like a minor change but I believe its impact will be significant especially in automation workflows.
I have already been deploying it and it works except it seems to only work with a formula that returns the email address. If the formula returns the contact name in the exact same formula it does not recognize the name as a contact. If I hover the mouse over the name returned by the formula smartsheet offers to add it as a new contact.
It seems odd because my formula is a simple "if" statement - here is the two if statements - the first one with emails is recognized as a contact and the other is not:
=IF(Region58 = "AMER", "BMorton@abccompany.com", IF(Region58 = "AUS", "GWilson@abccompany.com", "JGarza@abccompany.com"))
=IF(Region59 = "AMER", "Brian Morton", IF(Region59 = "AUS", "Gary Wilson", "Juan Garza"))
The names are a perfect match for what is showing in the name in "my smartsheet contacts". I changed the email address for privacy reasons.
The user experience and reports would be much better with names displaying. Is there a way to have it work with names and not just email addresses?
Kara Lumley
August 19, 2019 2:48 am
Hi Barry,
Thanks for the note - there was a flaw in the logic we found and it is being corrected with our next release - mid next week is the plan.
Best,
Kara
Hope that helps!
Have a fantastic week!
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Done !! Thanks
Thanks ! Done
Glad to help!
Happy to help!
The only flaw I can see with being able to enter "John Smith" and having it relate to the correct contact would be if you have more than 1 John Smith in your contacts list.
I want to setup automation for a distribution email list. This distribution email list should be tied to each form request. Do I have to add it to the form or can I add it, somehow, to the responses sheet.
Hello, I have a question about what I'm calling an errant alert. Here is the automation Trigger: When {{XYZ date}} changes to anything + Condition - {{Status}} = Phase 1 - In Progress + Alert someone, send to contacts in a cell = {{AA Assigned}} + Alert someone, sent to contacts in a cell = {{RE Assigned}} The automation…
Hi Smartsheet Community! I would like to ask if having a large amount of data (rows and columns) in a main monitoring sheet can affect the speed or performance of Automated Update Requests. We are currently using Smartsheet for monitoring and have several automations that send Update Requests to assigned users. I would…
