document builder - need contact name not email address
When using document builder, I am pulling a field that is a contact list column type.
when the program to build the document runs, it shows the email address instead of the contacts name.
How can I get the contact name to show on the document?
Answers
-
Hi @Peggy
You can try creating a helper column that will pull the Name from a seperate sheet with a list of name and Email address. you can use Index(Match()) or Datamesh if you have access to it and use that field in the doc buider instead.
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
You can use a helper text/number type column and just use a basic cell reference.
=[Contact Column Name]@row
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I have 6 columns that are contact list that would require 6 helper text fields. bummer.
thanks for both the suggestions!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives