IF Statement creating text result, not numeric value

bryan.mcfaden21551 · 08/22/17

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 · 08/22/17

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 · 08/22/17

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 · 08/22/17

Image of sheet

SmSulli · 08/23/17

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 · 08/23/17

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 · 08/23/17

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 · 08/23/17

Glad that it worked. Enjoy using Smartsheets.

Welcome to the Smartsheet Forum Archives

IF Statement creating text result, not numeric value

Comments

Categories