I have a SharePoint 2010 Consensus column that weights the values of six potential risk raters. My column names are [risk1], [risk2], [risk3], [risk4], [risk5], [risk6]. Any risk rater who rates an item has a choice of Low, Med, or High. Not all risk raters will rate every item and some items will have no rating initially.
My consensus logic is:
If all risk raters = Low then [Consensus] = Low;
If any risk rater (who rates) = Med and not High then [Consensus] = Med;
If any risk rater = High then [Consensus] = High
I can't get the formula right, any help would be greatly appreciated.