data uploader

Cameron McGregor · 06/27/20

im using this for the 1st time to fetch data from a one drive excel sheet, if i choose replace as a option on uploader the data is not refreshed when the source data changes, however if i pick replace, then all the data is refreshed, but the formulas i create a now deleted as its a replace (even linked cells to another smartsheet). Does anyone have any idea where i am going wrong here?

i dont want to use attach, it needs to be something that works in the background with no intervention as its a frequently changed source.

thanks in advance

Sean Morgan · 06/27/20

Hello @Cameron McGregor ,

In this instance, you will want to use "Merge", and then toggle "Add new rows", and disable "Update existing rows" .

See more on this here under "Select a Target Sheet and Upload Action": https://help.smartsheet.com/learning-track/integrations-and-add-ons/data-uploader

Please let me know if you have any questions

Regards

Sean

Cameron McGregor · 06/28/20

thanks @Sean Morgan , i still could not get this to work as you commented on, but i have managed to get it working on replace, and the VLOOKUP from another sheet doesn't get the links broken. i have scheduled this for tomorrow, as a test case...

one further question, i presume the onedrive excel workbook must be open for the data uploader to fetch the data?

Genevieve P. · 07/06/20

Hi Cameron,

Were you able to get this to run as expected? The OneDrive file should not need to be open for the uploader to work.

data uploader

Answers

Categories