Create Ranking Options in Smartsheets

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. ?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 03/09/21

    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.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Andrée Starå
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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

  • Bassam Khalil
    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.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!