I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.<\/p>
When I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the "Left" and "Right" formulas, but the "Right" formula only pulls the 5 decimal places, not the full 7. <\/p>
Is there any fix for the added decimals or a way to make the full string visible? <\/p>
Thanks you.<\/p>","bodyRaw":"[{\"insert\":\"Good morning, \\nI have specific coding for each line item that reads as 7 digits with a \\\".\\\" followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.\\nWhen I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the \\\"Left\\\" and \\\"Right\\\" formulas, but the \\\"Right\\\" formula only pulls the 5 decimal places, not the full 7. \\nIs there any fix for the added decimals or a way to make the full string visible? \\nThanks you.\\n\"}]","format":"rich","dateInserted":"2020-07-28T14:03:36+00:00","insertUser":{"userID":121795,"name":"Dominick Vargas","url":"https:\/\/community.smartsheet.com\/profile\/Dominick%20Vargas","photoUrl":"https:\/\/lh5.googleusercontent.com\/-K3DRXBl7OB0\/AAAAAAAAAAI\/AAAAAAAAAAA\/AB6qoq0e06wcsLG3HjNYaJDiLPrWcIBmsg\/mo\/photo.jpg","dateLastActive":"2020-07-28T17:09:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/70181\/long-decimals-7-digit-decimals","embedType":"quote","name":"Long Decimals - 7 digit decimals"}">
https://community.smartsheet.com/discussion/70181/long-decimals-7-digit-decimals
答案
嗨@Majid卡亚尼
Smartsheet对小数的最大支持是小数点后5位。
保罗在这篇文章中提出了另一种解决方案:
I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.<\/p>
When I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the "Left" and "Right" formulas, but the "Right" formula only pulls the 5 decimal places, not the full 7. <\/p>
Is there any fix for the added decimals or a way to make the full string visible? <\/p>
Thanks you.<\/p>","bodyRaw":"[{\"insert\":\"Good morning, \\nI have specific coding for each line item that reads as 7 digits with a \\\".\\\" followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.\\nWhen I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the \\\"Left\\\" and \\\"Right\\\" formulas, but the \\\"Right\\\" formula only pulls the 5 decimal places, not the full 7. \\nIs there any fix for the added decimals or a way to make the full string visible? \\nThanks you.\\n\"}]","format":"rich","dateInserted":"2020-07-28T14:03:36+00:00","insertUser":{"userID":121795,"name":"Dominick Vargas","url":"https:\/\/community.smartsheet.com\/profile\/Dominick%20Vargas","photoUrl":"https:\/\/lh5.googleusercontent.com\/-K3DRXBl7OB0\/AAAAAAAAAAI\/AAAAAAAAAAA\/AB6qoq0e06wcsLG3HjNYaJDiLPrWcIBmsg\/mo\/photo.jpg","dateLastActive":"2020-07-28T17:09:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/70181\/long-decimals-7-digit-decimals","embedType":"quote","name":"Long Decimals - 7 digit decimals"}"> https://community.smartsheet.com/discussion/70181/long-decimals-7-digit-decimals
但是请记住,这会将值存储为文本值,因此不能进行数学计算(例如SUM)。
欢呼,
吉纳维芙