Cross Reference Two Sheets
Hi I am very green smart sheet user and I need help typing up a formula.
I want to reference emails in a column from one sheet called "Active_Master Contact Sheet" in the column "Email" and enter that email into my "World Series Master Crew List" in the column "Personal Email" I am getting hung up on how to make that formula. The formula would look at the same full name from both sheets to find the email and enter it. Definitely struggling here and anyone's smart expertise on this is GREATLY appreciated it!
Answers
-
Hi @BrookeDawn
You can do an INDEX/MATCH formula to get the emails pulled in. Here's how your formula would look (after you create the reference using the link) =INDEX({Email column in Active Master Contact Sheet}, MATCH([Full Name column]@row, {Full Name column in Active Master Contact Sheet}, 0))
You will need to click on the "Reference Another Sheet" link in the Index part as well as in the Match part. Curly brackets in Smartsheet refer to cross sheet references, while square brackets refer to a column/cell reference in the same sheet.
Thanks,
Aravind GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 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!