why does smartsheets not Sum Cells with leading zero values

bday2329 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN}))

Mth/Yr = 9-2019

Prev Yr Mth/Yr = 9/2019

DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99)

The result from the SUMIF is 0 (zero)

Does SS not add values with leading zeros?

What am I doing wrong?

Thank you in advance for the appreciated help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!