Errors when editing calculated value columns in Microsoft Lists

Question

I am trying to use formulas to make columns functional in Microsoft Lists for a test portal.

The first formula I am trying to use is to assign a value of "1" if the correct answer is submitted from a 40 question test submission (form response added to list) and "0" if the incorrect answer is submitted. i.e. Question 6 response is column name "Q6", the formula to assign value 1 or 0 is column name "Q6V". Correct answer is B.

Formula 1: =IF(ISNUMBER(FIND("Correct Question Answer",Column Title)),"1","0")

Syntax in Q6V Column Formula section of Column Settings: =IF(ISNUMBER(FIND("B.",Q6)),"1","0")

The second formula I am trying to use to add up all value columns in a "Test Score" column.

Formula 2: =[Column1]+[Column2]+[Column3]

The third formula I am trying to use assigns pass/fail based on the test score in the portal. This particular test needs a score of 39 out of 46.

Formula 3: =IF([Test Score]<Minimum Score Needed To Pass ,"Fail","Pass")

Syntax in Pass/Fail Column Formula section of Column Settings: =IF([Test Score]<39, "Fail","Pass")

In all 3 formulas of the calculated value columns, I am getting either a "Sorry, we couldn't edit the column. Please try again." error or "The validation formula can refer to this column and not others." error.

What might I be doing wrong?

Answer 1

Dear BunkerTB,

Good day!

Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely.

Microsoft Community Moderator

Answer 2

Dear BunkerTB,

Here are screenshots of my test result(question column Q6 is Choice type):

Formula 1:

Formula 2:

Formula 3:

List:

Sincerely.

Microsoft Community Moderator