Adding Resume Scores

Options

Hello- I'm trying to find a formula that will help me get a total from resumes scores ranging from 0-3, note that they are in a multiple drop-down format, please see below:


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/16/20 Answer ✓
    Options

    Hi @Eric Gutierrez ,

    The column property Dropdown (Multi-Select) is causing your problem. Change the columns to Dropdown (Single Select) and then the formula from @Dan W. will work. I'd make a small adjustment and add an IFERROR.

    =IFERROR([Customer Service Experience]@row + [Technology Proficiency]@row + [Multitasking and Attn. to Detail]@row),"Error")

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Dan W.
    Dan W.
    edited 12/15/20
    Options

    Hello,

    In the [Resume Score] cell try the following formula:

    =[Customer Service Experience]@row + [Technology Proficiency]@row + [Multitasking and Attn. to Detail]@row

    Then apply it to the entire column by right clicking on the cell and select Convert to Column Formula.

  • Erick Gutierrez
    Options

    That didn't work, @Mark Cronk would you be able to assist?

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/16/20 Answer ✓
    Options

    Hi @Eric Gutierrez ,

    The column property Dropdown (Multi-Select) is causing your problem. Change the columns to Dropdown (Single Select) and then the formula from @Dan W. will work. I'd make a small adjustment and add an IFERROR.

    =IFERROR([Customer Service Experience]@row + [Technology Proficiency]@row + [Multitasking and Attn. to Detail]@row),"Error")

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Erick Gutierrez
    Options

    Thanks! @Mark Cronk so the formula didn't work for some reason, but the changing the drop-down from multiple to single allowed me to enter @Mark Cronk =SUM([Customer Service Experience]@row:[Multitasking and Attn. to Detail]@row) which did work.

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Glad you got a solutions. Thanks for using the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!