CONTACTS NAME TO APPEAR IN CELL NOT THE EMAIL
I am trying to run an automation workflow "ASSIGN PEOPLE":
Trigger = when rows are changed/TASKS(column)/Changes to/any value/when triggered
Condition=TASKS(column)/is not blank
Action-Assign people=EXPEDITOR(column)/a contact
The expeditor column is set up for contacts. When I run the automation it pulls up their email not their name.
Is there a way to force it to show the name of the contact not the email.
Also when I put the contact in manual with a drop down it pulls up their name not the email. Go figure.
Answers
-
Hey BILLY! Your post in ALL CAPS caught my attention 😁
This is happening because Smartsheet considers the email address as the "value" of the cell, whereas the user's Display Name is considered the "displayValue" of the cell.
Without going into something complex like getting into the API or using a third-party tool like Power Automate or Zapier, here's what I'd recommend:
- Create a column with the Column Type "Text/Number".
- Name this new column "Contact Name".
- Go to any cell in the "Contact Name" column and copy/paste in this formula (adjust the "Assigned to" text as needed if your column is named something different like "Assignee", "Owner", etc.)
=[Assigned to]@row
- Right-click that cell, then within the menu, select "Convert to Column Formula".
Now when you need to reference the person's name, you can do so in Automations by using {{Contact Name}}. For example, you could say {{Item Name}} has been assigned to {{Contact Name}} by {{Modified by}}. Please note that "Modified by" will always be an email address.
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!