Scoring Database Choices

1257 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2

I think you just need a complex formula with a lot of IF() functions:

That’s really useful, thank you. It’s going to take some time to get these formulas right!