I have created a list for a small quiz. The list includes columns with questions 1 through 5 which are choice columns with multiple answers or single answers. I am trying to score the quiz and have tried adding additionl columns between
the questions. It allows me to add a calculated column for the questions that have single answers and the formula menu includes a slection of that "question 2" number from the list to add to your formula. The questions that have multiple choice
answers do not appear in the list for you to select to add to your formula for that question.
Example: Question 2 - Single answer
Formula: Score 2 - =IF([Question 2:]="true",5,0) This formula scores 5 points if the answer is Correct and = true if it is incorrect it is 0 points.
Problem: Question 4 - Multiple answers
Formula: Score 4 =IF([Question 4:]="A;,B;,D", 5,0) This does not work. I have tried writing my own formula but I get an error everytime. Error Message.
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.
I do not generally work with formulas and this is farely new for me. This is Microsoft Share Point Moss 2007 .C
View Complete Post