Add a excel data sheet to an existing Smart sheet data base.
Hi,
I have an existing database on smart sheet that I used for my MailChimp campaign.
I now have the results of this campaign (who opened, who clicked) : I extracted the data from Mailchimp into excel.
I would like to import/ merge that excel data into my existing Smart sheet. How do I do this ?
Thanks for your help
Answers
-
Hi @Poolboys
I hope you're well and safe!
You could either use the Premium App, Data Shuttle or add a so-called helper sheet and use cross-sheet formulas (VLOOKUP or INDEX/MATCH) to match the data as long as you have something unique for each record that we can use. Then, you can copy the values in the main sheet and paste them as fixed or keep them connected to the other sheet.
Make sense?
Would that work/help?
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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!