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
-
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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives