当月
评论
-
以斯拉记 ✭✭✭优雅而强健。做得好，黛比
-
保罗新来的 ✭✭✭✭✭✭我不确定是否已经解决了所有的bug，但即使使用Debbie的解决方案，我也遇到了问题(不经常，没有明确的模式)，所以我已经制定了一些其他的选择，如果你碰巧遇到任何问题。
黛比的解决方案应该非常有效。应该……在相当长的一段时间里，我和Support来回切换，因为并不总是这样。他们没有修复这个错误，而是说我应该合并DATEONLY函数。
DATEONLY函数应该被设计为从日期/时间系统列中提取日期。
使用ISDATE函数应该可以工作。
但是我离题了……
我从来没有得到任何形式的确认，即存在一个bug(即使有多种形式的证明)，更不用说bug被修复了，所以这里是支持的解决方案。
=条件统计({月},DATEONLY (月(@cell)）今天=月(()))
．
Debbie的解决方案的一个变体(容易出现相同的错误):
=条件统计({月},和(ISDATE (@cell)月(@cell)今天=月(())））
．
我最初触发漏洞的公式(随机):
=条件统计({月},IFERROR (月(@cell), 0)今天=月(()))
．
黛比,
请不要认为这是我说你的解决方案是不正确的或不会工作。我只是在过去遇到了一些随机的问题。这里有一些细节…
[Column1]1:我的第三个解决方案，但将TODAY函数替换为实际的月份数。返回正确的计数。
[Column2]1:与上面相同的解决方案，但将TODAY函数替换为实际的月份数。不同的月份，但范围相同。返回一个错误。
．
该区域是一个日期类型列，其中有几个空格和两个包含文本的单元格。因此使用IFERROR的初始解决方案。这应该是有效的，但它并没有一直有效。有时会。有时它不会。
．
因为IFERROR随机抛出一个错误，所以我切换到使用ISDATE函数的第二个解决方案。最终得到与IFERROR相同的结果。有时它会起作用。有时它不会。
．
我从未想过使用DATEONLY函数，因为它用于从日期/时间系统列(创建或修改)中提取日期。在这个范围内，我没有任何类似的数据。
大多数细胞是日期，一些是空白的，还有一些是“待定”的。
．
我的解决方案大部分时间都是有效的，但偶尔也会失效。我最终发现了另一种解决方案，它涉及切换范围/标准集的顺序(我基于许多不同的标准进行计数)。
你可能会认为，只要是范围、标准、范围标准等等。，这应该无关紧要，但我发现如果日期范围是第一个，我会得到错误。
这说不通，不过没关系。我发现我需要把我的日期范围和标准放在第一个以外的任何地方。很烦人，但很有效。
直到事实并非如此。
．
就在那时，我终于找到了支持。
他们一直把问题归咎于有文字的单元格。好的。确定。但是为什么当引用的是相同的范围时，它有时会工作，而另一些时候却不工作呢?他们不能告诉我。他们只能告诉我使用DATEONLY函数。
．
所以尽管它没有意义…使用DATEONLY解决方案是我每次都能使其正常工作的唯一方法(到目前为止)．
thinkspi.com
-
黛比·索亚历险记 ✭✭✭✭✭✭天哪!多么美妙的旅程啊!谢谢楼主的分享。
这就是我喜欢这个论坛的原因，我们都可以互相帮助，互相学习。总有那么多东西要学，我不介意向任何人学习!
谢谢你，保罗。
亲切的问候
黛比
-
保罗新来的 ✭✭✭✭✭✭
帮助文章参考资料欧宝体育app官方888
类别
You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.<\/p>
<\/p>
If you are ok with the link being in another column, you can use this formula:<\/p>
=\"www.acmetickets.com\/ticket\/\" + [Ticket Number Column Name]@row <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":331,"urlcode":"hyperlink","name":"hyperlink"}]},{"discussionID":106493,"type":"question","name":"Need a formula to take a filename and alter the text","excerpt":"I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores. Filename example: JK_T1_L1_NewFile The filename always follows this rules - 2 letters_2 letters__2 letters _filename I…","categoryID":322,"dateInserted":"2023-06-15T14:06:14+00:00","dateUpdated":"2023-06-15T14:15:38+00:00","dateLastComment":"2023-06-15T15:31:51+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T18:10:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162413,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T17:43:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3373682885,"url":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","format":"Rich","lastPost":{"discussionID":106493,"commentID":380824,"name":"Re: Need a formula to take a filename and alter the text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380824#Comment_380824","dateInserted":"2023-06-15T15:31:51+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T17:43:16+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":"2023-06-15T15:34:11+00:00","dateAnswered":"2023-06-15T14:16:00+00:00","acceptedAnswers":[{"commentID":380785,"body":"
Try this:<\/p>
=LOWER(SUBSTITUTE([Column Name]@row, \"_\", \"\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
