Adding Resume Scores

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 ✓

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!