Combining SUM and RIGHT

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)

Find more posts tagged with

Formulas

Reports

functionality

Automations

Email Notifications

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.