I have a request for stock workflow that has 3 steps - the first is an email that goes to the branch manager, then upon approval, an email will go to the Purchasing manager, then finally to the Purchasing clerk. Is there a way to create the workflow to send to the specific branch manager of the branch selected in the branch column? For example, in Springfield, the branch manager is Darren, and in Peoria the manager is Shawn. If someone enters a request and selects "Springfield" as the branch, the trigger needs to send the first email to Darren, but if "Peoria" is selected, the first email needs to go to Shawn.
We had initially created a separate workflow for each branch, which wasn't as much of an issue when we only had 10 branches, but now we are triple that, and we have to open each list to see history instead of being able to see all activity in one list. Another problem is that some branches rarely have stock requests, and our workflows are being shut off after 90 days for those branches. If I can have everything in one list, then that would solve a lot of problems.
