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
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!