- hoosiercuseAsked on August 10, 2016 at 10:31 AM
I'm using the Orderable List Widget to have coaches rank the top 10 teams in their league. They have 50 schools to choose from. How can I calculate the overall tally so any first-place vote gets 10 points, a second-place vote gets 9 points, etc. Basically I just want to see the top 10 teams based on the scoring. When I open the Google spreadsheet I only get the ranking each team got. I could do this manually, but it seems like it should be easy.
This is a re-post of a comment on How to Integrate Form with Google Spreadsheet
- JotForm SupportKevin_GAnswered on August 10, 2016 at 11:49 AM
If I can understand correctly what you're trying to achieve, you want to set a value to the items in the widget as they're ordered.
Following your example, the first place should have a value of 10, the second place should have a value of 9 and so on.
Here is a screenshot about how I can understand what you're looking for:
As far as I know this does not seem to be possible with this widget, you can only add the options, but they cannot have a value on it.
However, could you please confirm us that your question was understood?
If possible, please provide us a bit more about what you're looking for, we will be glad to help you.