Is there a way to pre-fill a name in a contact column from another sheet?
The scenario is a sheet was created with project contact info (Name and Email), and a user wants to be able to start typing a name in the "assigned to" cell in a different sheet (RAID log) and it will pre-fill with the name from this other contact info sheet - isn this possible?
Best Answer
-
With native smartsheet and no add ons/APIs, you would need to add each contact to the contact list (column properties) in the sheet that contains the "assigned to" cell. Then, when the user types into the cell, the names will be offered for selection. You cannot dynamically reference the names/emails in the original sheet, unfortunately.
Answers
-
With native smartsheet and no add ons/APIs, you would need to add each contact to the contact list (column properties) in the sheet that contains the "assigned to" cell. Then, when the user types into the cell, the names will be offered for selection. You cannot dynamically reference the names/emails in the original sheet, unfortunately.
-
@KPH thank you for responding
-
No problem @Shonda . I am pretty sure there is a feature request for this somewhere. If I find it later I will share the link so you can vote (if you find it let me know and I will vote). Populating drop down lists from sheets would be great. Populating contact lists would be even better.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!