Data Shuttle Offloading Wrong Data?
I have a main data source which collects project information from different vendors.
Figure 1. Example of main sheet row
To work with outside vendors, we have public facing sheets that we offload data to using data shuttle.
Figure 2. Data Shuttle Offload Criteria
This data is then uploaded to the company's sheet where they can mark the task complete when they have finished their task.
Figure 3. Company Sheet
The problem I'm having is that projects that do not meet the criteria found in Figure 2. Are being found in the company's sheet, often as a repeat. If we look between Figure 1 and 3, these two represent the same project, however because the main sheet is checked in the IP Complete column, it should be filtered out of the data shuttle.
Has anyone else encountered this or know a work around?
Montana State University