IF Statement creating text result, not numeric value

bryan.mcfaden21551

Looking for guidance....I have an If statement which is creating a text value and not a numeric value, thus it won't allow me to choose those results and sum them up.   Any suggestions?

This is the If statement example I have which provides the end result number, but the value appears to be listed as text.  Then when I run a SUM total, I get 0 as my end result value

=IF([Technology Relevance]1 = "Y", "10", IF([Technology Relevance]1 = "N", "0"))

Thanks!

Mike Wilday

If you remove the Quotes you should be able to calculate with the number.

=IF([Technology Relevance]1 = "Y", 10, IF([Technology Relevance]1 = "N", 0))

bryan.mcfaden21551

Mike,

Thank you for responding.  I'm not sure what you are suggesting will work.   Here is more clarification on my issue:

=IF([Technology Relevance]1 = "Y", "10", IF([Technology Relevance]1 = "N", "0"))

My IF statement above is in cell Score1, pulling the result from the drop down choice in cell Technology Relevance3.  My issue is that the result pulled for each column labeled Score1, Score2, Score3, etc. do not return a numeric value where I can sum them up as a single total.

Hope this helps clarify.

bryan.mcfaden21551

Image of sheet

SmSulli

Bryan,

 

I agree with what Mike is saying.  Remove the quotation marks from the 10 and 0.  This will make them numbers (not text) and then you will be able to sum them.

 

Shawn

 

Mike Wilday

Hi Bryan, 

It should work just fine. You will need to update ALL of your score formulas and remove the quotations around the numbers to return a number value. Your quotes around the numbers are qualifying them as text and not numbers. When returning a number in Smartsheets you do not need to add Quotes. You need to return an actual number when performing calculations since text won't work. Make sure all three of your IF formula scores are not returning the number within quotes and you should see your calculations work. 

I also found this post that confirms my theories. https://community.smartsheet.com/discussion/formula-referencing-cell-populated-formula

 

bryan.mcfaden21551

Thank you Mike!    I completely understand now.   I made the adjustment and everything worked as you indicated.  Thanks so much for the assistance and patience!

Mike Wilday

Glad that it worked. Enjoy using Smartsheets.