SUM Formula

LHurley
LHurley ✭✭✭✭
in Formulas and Functions

I have written a formula to convert a word into a numeric value. When I try to add all the columns of the converted number to get the sum, it does not recognize the cell as a number so it returns a Zero. I feel like I need to convert the formula's conversion into a number instead of Text? Please help!

· Share on FacebookShare on Twitter

Answers

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi @LHurley, can you post the formula that you're using? Can you also post a screenshot as well, just so that I make sure that I understand the sheet as well

    Thank you!

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Report PDF generator that supports grouped and summarized reports
    • Automatic sorting, sorting with filters, saving sort settings
    • Hiding and unhiding columns, and spell checking

    · Share on FacebookShare on Twitter
  • LHurley
    LHurley ✭✭✭✭

    Here is the formula….=IF([Score #10]@row = "POOR (0 Look fors)", "1", IF([Score #10]@row = "FAIR (Min Look fors)", "2", IF([Score #10]@row = "GOOD (Many Look fors)", "3", IF([Score #10]@row = "EXCELLENT (Most Look fors)", "4"))))

    The scores for "Total Score by Interviewer" and "Score Summary" were manually calculated. I'd like a formula that will sum all of the "Numerical Score" Columns for each person. The above formula calculates the "Numerical Score" column

    image.png

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!