SUM Formula

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!

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!

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

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports

  • 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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!