Is it possible to cross reference contact columns in different sheets?
Hello,
I have two different sheets (in different Workspaces) that I am wondering if I can cross reference.
For instance, I have a sheet with a 'Developer Contact' column whose column type is a contact list. I also have a sheet with a 'Developer' column whose column type is a contact list. Wondering if I can set something up where when a 'Developer Contact' name is entered, it would look at the sheet with the 'Developer' column and if that name was not already in there, it would add the name into the sheet?
Answers
-
So you want to send new unique contact values to another sheet correct? Is this so you have a master list of developer contacts?
Do you own datamesh by chance? If not this can be done with a helper column and some automation.
-
Yes that is correct. We want the sheet with the 'Developer' column to be a master list of developer contacts! We do not have a license for datamesh at this time.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 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!