Use same contact list on multiple sheets
I'm looking for a way to have the same contact list on multiple different sheets. The ideal situation would be to have a contact list sheet where we update contact information and then use the values from the {name} column to populate the contact drop down... Is there anyway of doing this?
Another thought I had was just to update one contact list, but it seems that you can only do that from a sheet itself.
Ultimately, I am trying to avoid having to update multiple sheets every time there is a new contact which is pretty frequent.
Thank you,
Tayler
Answers
-
Will you need to be able to select multiple contacts in a cell for automations?
-
No just one contact.
-
In that case you can create your sheet that has the name in one column and the email in the other and then use cross sheet references in formulas to pull the email over into a contact type column. The formula would look something like this:
=INDEX({Reference Sheet Email Column}, MATCH([Name Column]@row, {Reference Sheet Name Column}, 0))
-
To add to Paul's excellent advice.
A solution that would be perfect for this use-case is the premium add-on, Data Uploader.
Is that an option?
More info:
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives