In a SP2010 environment, I have a couple challenges. I have a list of records that I need to add a calculated field (we'll call this column "STATUS Ratio) for each persons record. Each record has approximately 80 potential entries (columns of data) that can be toggled between 4 options (Yes/No/Partial/No Access). The first entry of each persons record is the column called "ROLE" (there are approximately 10 different types of roles or positions that people in the company are assigned).
Here's the challenge... First, based on the "ROLE" selected, only certain columns (of the 80 possible columns) will be available and all remaining fields not applicable for that ROLE need to be non-editable or non-viewable. Second, the "STATUS Ratio" field needs to calculate the ratio of completed fields for that person based on the role selected.
I really need help on this as quickly as possible to help build a jscript, HTML, or whatever would work on a SP 2010 page to achieve this task.
Thank you in advance for any help,