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

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

It is the apostrophe before the zero that throws things off.

Romano el Polako

Hey Paul,

Yes I suppose, even if I remove it, it is still visible once click on the cell. No option to remove it permanently.

I suppose it is a similar approach like in excel, by default in SmartSheet.

Thanks,

Roman

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.