Pull in data from Master File
Answers
-
Similar to my request above, I need to adjust it a little to pull in data from a corresponding field. Here is my scenario:
I have a master file in smartsheet that was imported from an excel file. A column of data was deleted and I need to get that data back in the smartsheet file from the main excel file.
I can use your formula above but need to modify it, and that's where I'm stuck. I would like to:
- look at column 1 in the smartsheet file and look for a match in column 1 of the excel file
- if there is a match, then I would like to return the contents at that row in column 2 of the excel file and populate column 2 at the row with that data
I'm sure I overcomplicated my explanation, but I hope that gives an understanding.
Thank you for your help!
Brad
-
Hi @bentlb3
It looks like Debbie has answered your question back on the original thread:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives