Orderable List: How to assign a value to the items in the widget?

  • Profile Image
    Asked 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 Forms with Google Sheets

  • Profile Image
    Answered 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.