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
-
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
-
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.
-
That didn't work, @Mark Cronk would you be able to assist?
-
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.
-
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.
-
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
Categories
Check out the Formula Handbook template!