Combining SUM and RIGHT

Kevin_smartsheet

Hello,

How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me?

A1, Customer satisfactionQ1: "Yes, 5"

B1, Customer satisfactionQ2: "Yes, 7"

C1, Customer satisfactionQ3: "Yes, 13"

D1, Customer satisfactionQ4: "No, 0"

E1, #UNPARSEABLE

=SUM(RIGHT([Customer satisfactionQ1]@row, 2),(RIGHT([Customer satisfactionQ2]@row, 2),(RIGHT([Customer satisfactionQ3]@row, 2)(RIGHT([Customer satisfactionQ3]@row, 2),(RIGHT([Customer satisfactionQ4]@row, 2)

Kevin_smartsheet

I found the answer!

I was missing VALUE. I also had to even up the digits to 2 digit answers on the form (5 changed to 05, 0 changed to 00)

=SUM(VALUE(RIGHT([Customer satisfactionQ1]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ2]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ3]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ4]@row, 2)

Hollie Green

You are missing a comma after the ) for Q3 the first time you have it listed. You also have Q3 in your formula twice.

Kevin_smartsheet

https://community.smartsheet.com/discussion/comment/355002#Comment_355002

Thank you, though after correcting, I am still getting the message "#UNPARSEABLE"

=SUM(RIGHT([Customer satisfactionQ1]@row, 2),(RIGHT([Customer satisfactionQ2]@row, 2),(RIGHT([Customer satisfactionQ3]@row, 2),(RIGHT([Customer satisfactionQ4]@row, 2)

If I use =(RIGHT([Customer satisfactionQ1]@row, 2)) then I receive the correct answer of 5.

If I use =SUM(RIGHT([Customer satisfactionQ1]@row, 2)) then I receive 0.

How can I use SUM and RIGHT together?

Kevin_smartsheet

I found the answer!

I was missing VALUE. I also had to even up the digits to 2 digit answers on the form (5 changed to 05, 0 changed to 00)

=SUM(VALUE(RIGHT([Customer satisfactionQ1]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ2]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ3]@row, 2))) + (VALUE(RIGHT([Customer satisfactionQ4]@row, 2)