Forms: Ranking choices in a question

Mandy Campbell

I'm working on a survey in a form. I have a question with five choices. I want the user to be able to put them in order of importance. For example, the choices are transparency, adaptability, positive attitude, dependability, and efficiency. I want the user to put these in order of what they deem to be most important vs. lease important. What is the best way to do this? Thank you.

Ramzi K

Create a sheet with one column per choice. Then create a form to capture choice rank (1-5).

I hope this helps.

Ramzi

Ramzi K

Create a sheet with one column per choice. Then create a form to capture choice rank (1-5).

I hope this helps.

Ramzi

Long@Concur

I'm tackling the same problem too. The issue with Ramzi's solution is that there isn't a way to prevent a user from selecting all 5 items as priority 1. I'm hoping there's a feature we're missing or a work-around solution. Thanks.

Jlaustse

@Long@Concur I'm encountering the same issue. If you find a solution, please let me know!

HeatherM

@Ramzi K is there a solution to prevent a user from selecting all 5 items as priority 1 as it looks like @Long@Concur and @Jlaustse had noted this as an issue in 2021. Is there a solution or way to create logic for this? I have 12 Topics and want to find out the top 5 priorities from participants. Thank you!