Essentially, I am helping to setup a SharePoint site that another department will for reviewing contracts to make sure they are correct. There are many different choice columns with
"Correct" "Incorrect" and "N/A" as options. I need to assign a point value to these columns, and they all add up to 100 points.
Normally I would do this with a simple IF statement. I would like to make the calculation all into one calculated column, but cannot get that to work. Not even sure if it can work.
I would like to avoid having over 40 columns designated just for finding scores, and then one for adding them all together. Is there a way to simplify these two calculated columns into one that also sums them together.
=IF([Column A]="Incorrect"0,3) =IF([Column B]="Incorrect"0,5)
So if Column A is "Correct" it is worth 3 points, but Column B would be worth 5.
I'd like the one "Total Score" column that adds these all together. Is that possible? I feel I'm missing an easy solution here.