Good morning everyone.
I have a sheet linked to a request form which based on the info submitted needs to be approved by a number of people. I have 14 approval workflows, based on country of the requestor, the total amount requested, and or reason for request. There are 4 to 5 approvals required based on the type of request. The issue is that after the first approval is captured, the remaining approvers receive 14 email notifications/requests to approve the request. Obviously I have tested by disabling some of the workflows and came to the conclusion that one email notifications/requests to approve is sent per active approval workflow on the sheet. Now I do not understand this, since all workflows have different conditions.
I have tried with triggers = ***when rows are added* or ***when rows are added or changed***
I will try and share this via screenshots but would appreciate any help. I have other sheets where approvals are required but only one approval - so difficult to see what I am doing wrong.
Thanks in advance.
PS:
I've attached screen shots of one full workflow for requests up to 25K. I've attached a screenshot of a second workflow similar to the first one but different in terms of the value of the request which is 25K to 100K; the approval steps are the same as the first workflow but just different people. These are the only workflows activated so I get 2 email notifications/requests to approve the request instead of 14; but only for all approvers after the first approval is captured.
