Copying Information Automatically (cell linking)

Gabby M.

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

Devin Lee

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.