# Need help with a SUM/LEFT formula

edited 02/28/23

I need a formula that will add the 1st number in different cells in a row.

So in the below picture, there will be different numbers in these cells, with text behind it. At the end of the row I would like to add all these numbers together and get an overall score.

Here is the SUM formula I have, just need to know how to pull in the left function to pull in the number at the beginning.

=SUM([1. Accuracy of product ordered]@row, [2. Condition of product and packaging]@row, [3. Product arriving on the anticipated day]@row, [4. Effectiveness of Help Desk support]@row, [5. Communication from Primary Hub]@row, [6. Accuracy of product ordered.]@row, [7. Condition of product and packaging]@row, [8. Product arriving on the anticipated day.]@row, [9. Effectiveness of Help Desk support.]@row, [10. Truck Arrive at anticipated time]@row, [11. Communication from Traffic Department]@row, [12. Staging of product upon delivery]@row, [13. Open communication with your hub/driver]@row, [14. Will Call program accuracy and process]@row, [15. Level of satisfaction with 3rd party carriers]@row)

Tags:

• ✭✭✭✭✭
edited 02/28/23 Answer ✓

You'll need to restructure your formula to follow this pattern:

=SUM(VALUE(LEFT([1. Accuracy of product ordered]@row, 1)) + VALUE(LEFT([2. Condition of product and packaging]@row, 1)))

Hope this helps!

• ✭✭✭✭✭
edited 02/28/23 Answer ✓

You'll need to restructure your formula to follow this pattern:

=SUM(VALUE(LEFT([1. Accuracy of product ordered]@row, 1)) + VALUE(LEFT([2. Condition of product and packaging]@row, 1)))

Hope this helps!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!