I have a tracking list consisting of the following:
The red boxes represent different persons (always the same). To track the status of the approval, I would like to add a new column and thought it may be possible as per calculated column, that displays a step counter based on the content of the specific red field.
The content is either "Pending", "Approved" or "Not required".
So, for example, a project requires 10 out of 20 possible persons to approve the idea, Status of 10 Persons (as represented by red bars in the picture) would be "pending". I would like the step counter to ask how many fields are stated as "Pending+approved" and take this amount (=X) and also ask for an amount of fields with content "Approved" only (=Y) and display this as simple as X/Y.
The result would be 5/10 for example if 10 persons were required (=pending or already approved) and 5 out of those already have the status "Approved". So first number has to be the amount of column contents "Pending+Approved" as a number and the second number the amount of column contents "Approved" as a number.
Can I achieve this functionality with a calculated column or is there another way?
Thank you for your help!