I have created a list in sharepoint on office 365. However, the users would like the list to calculate a weighted total based off of answers.
Did the contractor do X,Y,Z?
Did the contractor submit for x,y,x?
Answer 1 Answer 2 Answer 3
Is it then possible to go ahead and in each column of the list say if answer 1 then score = 1 if option 2 then score = 2. And do that for each question. And then have the total score populate in a field at the end of the list?