Jul 02, 2018 11:07 AM
I’m like to score someone’s responses to a form, but don’t know where I’d start.
For example, I have a row with three choices: rock, pop, and jazz. Depending on the choice you make on the form it then gives you a score. Say I choose rock and it gives me a score: ‘cool’.
I’d then like to build on that with other choices. So the form might ask if I prefer CDs or records. I choose records, and it gives me an updated score linked to my original choice. I’m now ‘very cool’.
Does that make sense? And is it possible?
Jul 02, 2018 02:51 PM
I think you just need a complex formula with a lot of IF()
functions: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas
Jul 03, 2018 08:45 AM
That’s really useful, thank you. It’s going to take some time to get these formulas right!