Spreadhseet Approval - Cost Center Based

Summary:

Invoice Approval Rules based on Distribution Cost Centers

Content (please ensure you mask any confidential information):

I have a requirement to configure invoice approval rule based on Cost center as below. If Cost Center is (101,102,103) then approal should go to John and if it is 105 then Ram etc.

In case if Invoice is having two lines with two cost centers as 101 and 105 then approval must go to John and Ram parallel. Please advise as to how to write rules in spreadsheet to achieve the same.

Version (include the version you are using, if applicable):

23D

Code Snippet (add any code snippets that support your topic, if applicable):