Hello!
Happy Friday! 😀
I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form connected to the tracker. The tracker will then use Data Shuttle to pull over the quantity, description, and item number of each supply item listed in the excel file. The item number will be used to pull in the quantity of each item we may have in inventory utilizing the VLOOKUP formula and our Inventory Tracker.
Now, I've tested the sheet multiple times. The VLOOKUP works great. The Smartsheet form captures the input information and attaches the excel file to the row like it's supposed to. The problem comes with the Data Shuttle feature. If I attached the file to the row/sheet manually, the data from the file flows right into the sheet but when the file is attached via the Smartsheet form, the Data Shuttle feature does nothing.
So, does the Data Shuttle workflow not run if the file is attached via the Smartsheet form or am I just doing something wrong?
Thanks,
Dorothy