Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Aug 12, 2021 02:00 AM
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
Aug 12, 2021 04:53 AM
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.