长小数- 7位小数
早上好,
我对每行项目都有特定的编码，读取为7位数字，后面跟着“。”和另外7位数字。实际上，它看起来像一个长十进制。智能表认为这是一个小数，并将其四舍五入，当我离开单元格时消除最后两位数字。失去最后2位数字改变了数字，使我的编码混乱。此外，对我的工作表具有只读访问权限的人无法看到所需的完整编码字符串。
当我试着扩展小数点时，它停在了5。因此，我尝试创建一个公式，使用“左”和“右”公式，将一列分成两个单独的列，但“右”公式只提取小数点后5位，而不是完整的7位。
是否有任何修复添加的小数或使完整字符串可见的方法?
谢谢你。
最佳答案
-
保罗新来的 ✭✭✭✭✭✭
答案
帮助文章参考资料欧宝体育app官方888
类别
The HAS function is built specifically for multi-selects. Try something like this:<\/p>
=COUNTIFS({Program\/Grouping}, HAS(@cell, $Category@row))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-20 17:29:32","updateUser":{"userID":148332,"name":"Shonda","url":"https:\/\/community.smartsheet.com\/profile\/Shonda","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2022-12-20T19:27:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":98926,"type":"question","name":"formula help","excerpt":"Hello I have a check box to auto check to indicate next month however; I've run into an issue with January not checking and I believe it has to do with it being a new year. I found a formula that someone needed to look back from January to December and i tried to make it work for next month but it's not working. How can I…","categoryID":322,"dateInserted":"2022-12-20T15:15:03+00:00","dateUpdated":null,"dateLastComment":"2022-12-20T15:46:26+00:00","insertUserID":96351,"insertUser":{"userID":96351,"name":"Jason Jordan","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Jordan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-20T15:45:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":96351,"lastUser":{"userID":96351,"name":"Jason Jordan","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Jordan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-20T15:45:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":3343102889,"url":"https:\/\/community.smartsheet.com\/discussion\/98926\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98926\/formula-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98926,"commentID":354948,"name":"Re: formula help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354948#Comment_354948","dateInserted":"2022-12-20T15:46:26+00:00","insertUserID":96351,"insertUser":{"userID":96351,"name":"Jason Jordan","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Jordan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-20T15:45:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-20T15:45:45+00:00","dateAnswered":"2022-12-20T15:24:31+00:00","acceptedAnswers":[{"commentID":354939,"body":"
=IF(MONTH([Vacation Start]@row) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 26) + 6), 1, 0)<\/p>
<\/p>
Give that a try<\/p>"},{"commentID":354946,"body":"
Yes, this will work throughout the year.<\/p>
Basically what it is doing is putting together a date that is the 26th of the current month and year. If you add 6 to that date, it is the 32nd. No matter the month, there is never 32 days in the year. So now you have a date in the next month. <\/p>
Take the month from that calculated date, and compare it to the month of the date you want to, and return if they match or not.<\/p>
Technically you could do this with many different numbers. For example you could say 28 and 4, or 27 and 10. as long as you pick numbers that when added together are greater than 32, and the second number is less than 28, you are good.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-20 15:45:45","updateUser":{"userID":96351,"name":"Jason Jordan","url":"https:\/\/community.smartsheet.com\/profile\/Jason%20Jordan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-20T15:45:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
