Update multiple sheet column dropdowns from one source sheet using Bridge
We have a master project list that we reference to update project select dropdowns on 50+ sheets in our solution.
We'd like to use Bridge to update all of those dropdowns, but we haven't found a way to update multiple dropdowns with one workflow. The workflow works fine for updating one sheet (the circled portion below), but we keep encountering errors when we try to update another sheet dropdown. If we can't figure out another way, we'll have to create separate workflows for all 50+ sheets and include the Get Sheet and Array functions for every one of them.
Here's what we've tried:
- We added another Update Column module for the next sheet after the circled portion below.
- Result: The workflow ran through the circled portion with no issues, but acted as if the second Update Column module didn't exist. There were no errors; it just stopped after running through the circled portion.
- Then we tried a child workflow as shown below.
- Result: The child workflow ran, but when I tried to reference the array values, I received an error (see screenshot below). Will child workflows not identify references from parent workflows?
Child workflow error message:
Any insight is greatly appreciated!!
Tagging some Bridge friends 🙂