Data Shuttle - Upload Data from Attachment on Target Sheet
I want to create a tracking sheet where certain columns on a row automatically pulls the data from an excel document that I attach on that row (source and target sheet would be the same).I don't want any information to be overwritten on the sheet, just every time I go down each row and attach the excel document, it's specifically for that row and only puts the data in the row that attachment is on.
Is this possible and any suggestions of how to go about doing that? I've had no luck so far.
Thank you!
Best Answer
-
There currently isn't a way through DataShuttle designate the exact row that new information will be populated on to. The workflow will either replace all the rows in the current sheet, update existing rows with the matching ID, or add new rows that don't exist to the bottom of the sheet.
This means you could only select "Add rows" from the Row Options and then when you attach a file it will only add new rows to your current sheet. Then once the data is added you can move that row to the correct place.
There's a free Data Shuttle webinar coming up on March 16th, if that would be helpful for you! See: https://help.smartsheet.com/webinars
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
There currently isn't a way through DataShuttle designate the exact row that new information will be populated on to. The workflow will either replace all the rows in the current sheet, update existing rows with the matching ID, or add new rows that don't exist to the bottom of the sheet.
This means you could only select "Add rows" from the Row Options and then when you attach a file it will only add new rows to your current sheet. Then once the data is added you can move that row to the correct place.
There's a free Data Shuttle webinar coming up on March 16th, if that would be helpful for you! See: https://help.smartsheet.com/webinars
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 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