Cells not being recognized as numeric values

Options

Need help figuring out why Smartsheet is not recognizing cells as numeric value - I think that's the issue. When try to sum the values in this example the return is $0.00.


This is the formula I'm using to sum the column:

=SUM([Order Submission Avg]1:[Order Submission Avg]12)

This is the formula in the cells I'm trying to sum:

=IF({OrderSubmitFeb} = "", "", IF({OrderSubmitFeb} <= 1.5, "$200", "$0"))

I've tried making sure the cells are set as a currency.

I'd appreciate any suggestions on getting this figured out.

Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Travis Horton

    When you added a dollar sign to the numbers within your IF, smartsheet began treating your data as a text string. Also, when using numbers, don't enclose them in quotes. This also makes smartsheet believe you want to treat the number as text.

    Try this.

    =IF({OrderSubmitFeb} <>"", IF({OrderSubmitFeb} <= 1.5, 200, 0))

    As pictured in your post, use the dollar sign formatting to add the dollar sign to your value once it behaves numerically.

    Does this work for you?

    Kelly

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓
    Options

    Hey @Travis Horton

    When you added a dollar sign to the numbers within your IF, smartsheet began treating your data as a text string. Also, when using numbers, don't enclose them in quotes. This also makes smartsheet believe you want to treat the number as text.

    Try this.

    =IF({OrderSubmitFeb} <>"", IF({OrderSubmitFeb} <= 1.5, 200, 0))

    As pictured in your post, use the dollar sign formatting to add the dollar sign to your value once it behaves numerically.

    Does this work for you?

    Kelly

  • Travis Horton
    Options

    That did the trick. Thank you!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!