Multiple workflows for a Product Approval Process (URGENT)
Everyone,
I hope you are doing well, I wanted to reach out to you to try to find a solution to the current problem I have. The Smartsheet spreadsheet that I created managed the information of 4 different plants. The process is:
(1) The information is entered in the sheet by submitting the info throw a form. One of the questions of the forms is What plant are you from?
A. Victorville B. California C. Alabama D. Michigan
(1) Then, throw a workflow the quality Department of that plant received an email to submit information to this sheet it is a (Request for Update). (3) once the information is uploaded, the Quality Manager needs to approve the information entered in the system by approving the approval process (Request for Approval). (4) Then, the workflow sends another email to the customer asking for their approval (5) once the customer approved it, (6) then the workflow sends an email to a distribution group.
The first issue I encounter was that the workflow that I created has multiple conditionals with the same information in each condition. The condition is the plant.
e.g.
If the plant is Victorville, then, the workflow will trigger Victorville Plant flow. however, at the approval process is where I had a problem because all 4 plants use the same approval cell, and Smartsheet does not allow that.
I now created 4 workflows the same way I created the initial workflow but now each plant has its individual flow. However, once it goes to the approval process, I believe it triggers the other workflow because all the plants are getting 4 emails with the exact same information.
At the bottom of the email says: you are receiving this information because you are subscribed to the Victorville workflow, the other email says the same thing but California, Alabama, Michigan Workflow.
I don't want the customer to get 4 same emails. I need to find a solution on this.
Any Idea on how to do this?
