Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Need help with a SUM/LEFT formula

edited 02/28/23 in Formulas and Functions

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:

Best Answer

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

    @Matt_Fastenal1

    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!

Answers

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

    @Matt_Fastenal1

    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!

Trending in Formulas and Functions

  • I'm trying to create a SUMIF formula that looks at the salesperson name in a column and adds up or totals their $ sales in another column. To ultimately show in Dashboard of Totals Sales by Salesperso…
    User: "Allan Z"
    Answered ✓
    9
    2
  • Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
    User: "stratman"
    Answered ✓
    15
    2
  • I have a sheet that compiles all the responses from a form. The sheet has multiple start and end date columns, but only one start and one end date cell is NOT blank depending on the activity selected …
    User: "m_anderson"
    Answered ✓
    13
    2