I’m trying to design a 360 evaluation tool to allow all project team members to evaluate each other. I’m using a repeat group to allow each member to evaluate only as many members he want to evaluate.
The form consists of a set of statements which the respondent can evaluate as (I don’t know, insufficient, good, distinguished).
The challenge is that all members will get “distinguished” on all aspects if they were allowed to give that grade to everyone. So, I would like to allow each member to use the “distinguished” grade a limited number of times regardless of how many repeat groups he adds (i.e. regardless of how many colleagues he will evaluate only one colleague should get this grade).
Any ideas how to achieve this?
I’m thinking of creating a calculation that counts how many times this grade is selected in each repeat group and show a note when this number exceeds a defined limit. Can this be done?