Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

IF Statement creating text result, not numeric value


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"))



This discussion has been closed.