Approval by cost center manager when multiple approvers exist

Summary:

A single approval is required from EACH cost center. In scenarios where a single cost center has multiple approvers only one is required.

How can we code this in the Payables Workflow spreadsheet to meet both requirements?

Content (please ensure you mask any confidential information):

Example:

Cost Center:

135645 - has one cost center manager - John Doe

135999 - has two cost center managers - Emily Employee, Sam Supervisor

196588 - has one cost center manager - Denise Director

Scenario 1 - Invoice coded to 135645 and 196588 would require approval from both John Doe AND Denise Director.

Scenario 2 - Invoice coded to 135999 would require approval from either Emily Employee OR Sam Supervisor