Copying Information Automatically (cell linking)
Hello Smartsheets community.
I currently receive an excel doc on a weekly basis, I would like to take some of the information from this document and have it automatically populate on a smartsheet I have. (specific columns)
Since the document is updated on a weekly basis, I am not sure how I can go about linking information without deleting previous data.
Is cell linking the best option?
thanks
Best Answer
-
Hard to tell by your description here. In some cases I sort the sheets by date and copy/paste them in to fill in the information. In other cases, I paste in the new data into the bottom of the sheet and have a column that counts the unique column which triggers an automated move to a trash sheet when the count gets larger than two. Lastly, I have a data dump sheet which I paste in all the information to and another sheet references that data dump sheet and uses similar logic to the previous example but pulls in the highest matching values of the unique column count. The approach all depends on how much data you have. Once you reach too many the only real option is lots of manual work or purchasing the Smartsheet Data Shuttle.
Answers
-
Hard to tell by your description here. In some cases I sort the sheets by date and copy/paste them in to fill in the information. In other cases, I paste in the new data into the bottom of the sheet and have a column that counts the unique column which triggers an automated move to a trash sheet when the count gets larger than two. Lastly, I have a data dump sheet which I paste in all the information to and another sheet references that data dump sheet and uses similar logic to the previous example but pulls in the highest matching values of the unique column count. The approach all depends on how much data you have. Once you reach too many the only real option is lots of manual work or purchasing the Smartsheet Data Shuttle.
-
Hi @Gabby M.
I hope you're well and safe!
Here's a possible workaround or workarounds
- I recently developed a solution for a client where we used a so-called import sheet to add information, and then that would populate the main sheet.
- The Premium app Data Shuttle would be perfect if you'd like to automate it completely.
Would any of those options work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
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 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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives