How to attribute a score to 11 items (after asking 3 questions on each), and then making the person choose 3 items from 6 which had the better score ?

@Liz @Denis From Paris - this is something that i have raised with the Product team… it’s easy enough (though long and involved lol) to create the logic rules to capture the highest score in native Typeform logic but it gets really complicated if you then have to remove that high score from your logic array and then calculate the next one, then the next one. 

And it is not easy in Google Sheets - downright ugly if i say so myself. I was trying to do this for another client and the idea was to try and use something like the RANK function. BUT that only works on a column and not on a row of data … so to do that you would have to do an arraytransform to take the row data into a column, do the rank (or maybe a sort) and then (re)write the sorted transform back into the row in different cells .. 

and even if we could do this sort of thing inside Typeform at the moment, to be able to use the top 6 (as in the question above) as ‘items to rank’ in a ranking question is currently not possible.  

Not sure if you pushed the data out to Airtable, if airtable could do the calculations for you, then push the questions and the options (top 6 items) into a form created on the fly … webhooks api or magic and microwaves…. 

des