Create Ranking Options in Smartsheets

Jesika McNeil

I have three options available and I want individuals to be able to rank them in order of importance to them from 1 to 3. Is there a way to do this. ?

Bassam Khalil

Hi @Jesika McNeil 

Hope you are fine, you can add a helper column with 1 To 3 beside your option and the individuals will select the option and the rank for each option. or you can create 3 dropdown column each of them contains the 3 option and you name those column 1,2,3 and the individuals select in each column his option.

Andrée Starå

Hi @Jesika McNeil

I hope you're well and safe!

To add to Bassam's excellent advice/answer.

You could maybe use the Conditional Logic in forms to structure it so when one value is selected, and it's only possible to select what's left.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jesika McNeil

@Bassam.M Khalil thank you. I'm not sure I understand your instructions. Do you have an example you could post?

Bassam Khalil

Hi @Jesika McNeil 

If you could add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question. and create a sample to match your application.