data uploader
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
Answers
-
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
-
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?
-
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.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives