How do I score out a survey and have it populate in another column?

SmartSheetAdmin

Hi everyone ,

I am attempting to create a scoring system for a survey based on this type of scoring below.

These are the survey questions and it already built in a sheet.

Thanks in advance for the support.

Paul Newcome

If all question columns are next to each other, you can use:

=(COUNTIFS([First Column]@row:[Last Column]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([First Column]@row:[Last Column]@row, OR(@cell = "Satisfied", @cell = "N/A"))

Paul Newcome

You need to update the column names in the formula to match the column names you are using in your sheet.

Paul Newcome

If all question columns are next to each other, you can use:

=(COUNTIFS([First Column]@row:[Last Column]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([First Column]@row:[Last Column]@row, OR(@cell = "Satisfied", @cell = "N/A"))

SmartSheetAdmin

Where would insert those?

Paul Newcome

The above formula would go into its own column that would house the scoring of the surveys. You would need to update the column names to match what you are actually using in your sheet.

SmartSheetAdmin

Not sure if I am inputting correctly.

Andrée Starå

Hi @SmartSheetAdmin

I hope you're well and safe!

Can you share the exact formula you're trying?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@SmartSheetAdmin Can you provide the exact formula you are using that is throwing the error?

SmartSheetAdmin

=(COUNTIFS([First Column]@row:[Last Column]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([First Column]@row:[Last Column]@row, OR(@cell = "Satisfied", @cell = "N/A"))

Paul Newcome

You need to update the column names in the formula to match the column names you are using in your sheet.

SmartSheetAdmin

So, I can name the "[First Column]" Training and the Second would be Training 2 etc?>

SmartSheetAdmin

I got it !! Thanks everyone.

SmartSheetAdmin

How would I go about changing the points for the formula?

=(COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, OR(@cell = "Satisfied", @cell = "N/A"))

Paul Newcome

It depends on what you want them to be.

This part assigns two points to "Exceeded Expectations":

=(COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, OR(@cell = "Satisfied", @cell = "N/A"))

This part assigns one point to "Satisfied" or "N/A":

=(COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, OR(@cell = "Satisfied", @cell = "N/A"))

SmartSheetAdmin

If I wanted to have N/A = 0?

Paul Newcome

In that case you would remove the "N/A" portion from the COUTNIFS that assigns one point.

=(COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, @cell = "Exceeded Expectations") * 2) + COUNTIFS([Labor Management Tools]@row:[Power Bi]@row, @cell = "Satisfied")