Has anyone ever done a workflow where a task is assigned to multiple people with the possibility of multiple outcomes and the least of those wins. (weighted outcome)
For example I need to send a task to 3 people. They could answer Approved, Conditional Approved or Not Approved. I need the least of those to take over the status.
I cannot use the majority wins cause it needs to be the lowest approval level/value that wins.
So for example:
User A= Approved
User B= Approved
User C= Conditional Approval
Overall Status = Conditional Approval
User A= Approved
User B= Not Approved
User C= Conditional Approval
Overall Status = Not Approved
User A= Approved
User B= Not Approved
User C= Not Approved
Overall Status = Not Approved
Anyone have any idea on how to go about this?