+1Hello everyone,
I am new to airtable. I have a survey and each question has a single select field option for the answers with a certain amount of points. How can I assign a number to each single select field value e.g. a=0, b=1, c=2 and d=3 so I can add up these points.
Hope to hear from you.
Thanks
Best answer by Christian_Sabou
It's a pleasure! Please mark this post as solved 🙂
+5This will require an additional Function field with a switch statement:
SWITCH({Answer field},"Answer one",1,"Answer two",2,0)
The last 0 being the default value if nothing is selected
+1Hi Christian,
Thank you for the quick response. I tried it and I get an error prompt (see attached file). Am I missing something?
+5You are missing the end parenthesis. The hint is the little squiggly line under the front one. Otherwise it should work.
+1You are missing the end parenthesis. The hint is the little squiggly line under the front one. Otherwise it should work.
Now with the end parenthesis added it does not seem to work.
+5Oh, It's the closing bracket that's extra now.
SWITCH({Answer field},"Answer one",1,"Answer two",2,0)
+1It's a pleasure! Please mark this post as solved 🙂
Hi,
Is it possible to add multiple columns to the SWITCH formula to have a sum of single select columns that have the same options and points?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.