Sharing data among multiple sheets
I've created a sheet for the company to manage all Contacts. In a new sheet to capture more data about orders for a company, we would like to be able to pull over name and email address of a Contact when the Organization name matches in both sheets. I need this information to always be accurate in linked sheets when Contact info is updated in the Contacts sheet. What is the best way to achieve this?
Answers
-
You can probably accomplish this with INDEX/MATCH column formulas on your orders sheet. The format of your formulas would be:
=INDEX({What You Want to Return}, MATCH([Organization on your current row]@row, {Organization on Contact Sheet}, 0))
Your capacity to link sheets like this is not without limits - check this out for additional info:
Depending on the size of your sheets, the frequency with which you have cross-sheet lookups, and the overall complexity as you continue to use this - you may want to investigate Data Mesh. It's a premium app you may be able to use, that has a similar functionality without the need for formulas.If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!