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
Answers
-
It is the apostrophe before the zero that throws things off.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!