Hi,
Is someone familiar with a simple way of ranking items in a SharePoint list? For example, if I have 3 questions being asked and each should be ranked from 1-3 uniquely is this possible?
What food do you like the most?
Pizza
Wings
Hamburgers
Each would have a drop-down with numbers 1 to 3 and if one answer changes, the others change as well (similar to the column ordering).
You might try a multi-lookup column. Your 3 choices would be list items in a separate list, and you would add a column to your question list that’s a multi-lookup to the other list. The values aren’t auto-sorted, so the order that the user selects the items would be your ranking. The only problem is that SharePoint doesn’t specific limits on the number of entries. It would let you add just 1 or 2 instead of 3. You could write some validation using JavaScript to handle this, though.
Thanks. Actually, I noticed that the survey has a Rating Scale column which is exactly what I need but for a custom list. Any idea if there are 3rd party or CodePlex solutions that do that?
You would need to use some JavaScript to accomplish that.
