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'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…
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…
