Skip to main content

Hey guys,

so I have a test which contains a series of questions. Each question has a single select field with 3 answers. Each of these answer has a different value (for example: answer X = 9 pts; answer Y = 3 pts; answer Z = 0 pts). I need to create a field where to insert a formula that generates the exact amount of points with every answer.

Something like this:

“question 1 > IF answer = X > 9 pts; IF answer = Y > 3 pts; IF answer = Z > 0 pts”


Your help would be greatly appreciated,

thanks a lot

Hi Federico. The SWITCH statement is your friend here.


SWITCH({single select field name},

'X', 9,

'Y', 3,

'Z', 0)

You would need a formula field with a statement like this for each question field.


Reply


Terms & Conditions