long numbers are rounding up the last number
Answers
-
Hi Julie,
I can't replicate your problem.
Can you provide a screenshot and the number and anything else that would be helpful?
Best,
Andrée Starå - Workflow Consultant / Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
First, congratulations that you need 16 digits to distinguish your customers from each other.
Second, I recently reported an issue with long integers to Smartsheet support. I was getting strange results when taking a column's ColumnID and converting it to a string. Smartsheet's ColumnID, RowID, SheetID's are typically 16 digits (I don't know if they all are, I don't think so.)
Maybe what you are seeing is related or similar.
The behavior I was seeing (addition unexpected characters added to the string) was not for every number and it was reproducible for some 15 digit numbers as well.
I suggest contacting support@smartsheet.com
Craig
-
I am on the phone with SS Support with a similar problem now. After Data Shuttle drops a 16 digit value into a cell, it is transforming the final character (on-screen) into a different number. However, if I copy that value out of SS and paste into Excel to compare to the source data, it is correct. That transformed value is causing errors with some index/match formulas across sheets. If I manually copy/paste the value from source csv into a text cell in any Smartsheet, the full value is honored.
The ironic part is my data source is Smartsheet's own Published Items report; the 16 digit value is the published asset ID.
Has anyone had a similar experience?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives