How can I set AP Invoice approval to pass 1st, 2nd, and 3rd groups when amount is huge (Spreadsheet)

3:32PM

I have a requirement to configure in spreadsheet , let's say I have 3 Approval Groups (AG1, AG2, AG3)

If Invoice is raised between 1000$ to 5000$ then it has to go AG1 which 2 people and any 1 can approve.

If Invoice is raised between 5000$ to 10000$ then it has to go AG1 first and then AG2 next which has 3 people and any 1 can approve from AG1 and 1 from AG2.

Similarly for 1M$, it has to get approved by 1 person from each group AG1 , AG2 and AG3.

I followed 2 approach (Please find the attachment)

Approach 1:

First I tried Group in First responder routing to all 3 level and created invoice with 1 M. In this case all 6 people in 3 AG's got notified, so any 1 can approve.

How can I set AP Invoice approval to pass 1st, 2nd, and 3rd groups when amount is huge (Spreadsheet)

Howdy, Stranger!