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.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
