Oh goodness! That’s definitely a lot of comparisons! I’ll probably still default to ​@john.desborough on this one to see if he has a hacky workaround, as we sadly don’t have a way to do this within the builder itself easily (you’d definitely have to use variables/calculations/etc!). 

​@cherylwoodhouse - will there be ties and a tie-breaker question? or will there always be a ‘clear winner’? 

the big issue, even in Google Sheets (or excel) is that any “sort ascending value” functions are column-based and not row-based. With your typeform data going into a single row in the Sheet, you would need to do a ‘transform’ of the row data into a temporary column, sort descending, and then transform the column back into the ‘sorted row cells’ so that you had the highest value. still doesn’t address any ties if you solely base it on the raw scores. 

you CAN do this with logic rules and it isn’t 10B logic rules.. but it comes down to IF You want a tie breaker question for each possible tie at 10. if you want a simple tie breaker ie if 2 or more are tied at 10 then go to a question that lists all the options (the 10 you mention) and choose 1. and spin the wording so that you tell them you are doing this to create a starting point for them…. and then you can manage any other selections from an email sequence/nurture sequence.. 

just a thought

des

There will need to be a tie-breaker question (and I haven’t addressed that in the build yet unfortunately.)

The only other thing I’ve considered is just doing it as a single question, with a rating matrix of sorts? Most agree to least agree on all 10 statements within a single question. Would that “spit out” the top rated statements more easily?