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'.

see:


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.

Thanks,

Roman

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!