Forum Discussion
I would build it a bit differently.
With a table called Dynamic Approvals you can assign an unlimited number of Approvers to the Project.
Two summary fields between the Projects table and the Dynamic Approvals table will tell you how many Approvers there are for the Project and how many are Approved.
You then make both of those Look Up fields in the Dynamic Approvals table.
When your final Approver sets the status in their record to Approved
# of Approvals = # of Approved
I would then fire a Pipeline to go to the Static Approvals table and change the status of each to Pending Approval which then sends those Users a Notification to do their review.
It is a bit more complicated table structure but you get more flexibility. What if you need One Static and Five Dynamic? It will just work for you every time because the architecture makes it happen instead of a certain amount of hard coded fields.