Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with IF formula choosing between three options

Topic Labels: Formulas
1149 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Federico_Triulz
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Reply 1
augmented
10 - Mercury
10 - Mercury

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.