Issue with 0 prefix in the reference number


Hey SmartHeads!

I have a weird issue in SUMIF formula:

ASINs Value Total SUM:

=SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)])

it works perfectly fine for all numbers under Tracking ID Number, except the one which starts with '0'.


when I create a copy with the same row, but without 0, it works in mysterious way:

Value of single item is 139.78, hence after adding a duplicate each row should show 279.56

When I remove duplicate, value return to 0:

Please let me know if you have any idea how to make sure that such scenarios will be also calculated correctly.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!