Hello,
I am trying to create a "tracker" that show the progress of a shipment that contains multiple steps that are updated as each step is complete.
So essentially the Tracker sheet would pull all the new entry submissions and update submissions from the dump sheet, to one row on the Tracker for each shipment.
There are multiple people updating this tracker sheet. I was hoping to be able to use a form (for ease) and a "dump" sheet that holds all the updates that would then update to the "tracker" sheet. But I am having troubles getting the tracker row to update as each of the update form submissions are entered.
I have tried using data mesh- it pulls the submission for a new shipment, but then doesn't pull the update submissions to the new shipment row on the tracker. I used Add and Copy setting.
I am having troubles with the multiple updates to the same row.
An example of how many update a row with have.
Form submission 1- New- new shipment request
Form submission 2 - Update- packaged date
form submission 3 - Update- Shipped date
Form submission 4 - Update Arrived at requestor
Form submission 5 - Shipment Complete
I have tried Vlookup but doesn't seem to be able to do what I want. Perhaps I don't have the right formula?
I want this to be automated so asking for updates is more monitoring then what is wanted with this sheet.
Any suggestions on how to get the submissions from my dump sheet to the Tracker sheet into one row?
I am open to using a different setup to achieve this also.
Thanks in advance,
Emily