Adding Resume Scores

Erick Gutierrez

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:

Mark Cronk

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

Dan W.

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

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

Mark Cronk

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

Erick Gutierrez

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

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

Mark