过滤器只显示这周的日期??
我正在为我们的建筑公司做一个工程进度表。
我想能够有一个过滤器，只显示“开始日期”，等于这个星期或这个月。
这有可能吗?
评论
-
她名叫Stara ✭✭✭✭✭✭你好,
是的,它是。
试试这个。
编辑:更新了更简单的解决方案。
我的示例是针对当前一周的，但您也可以设置为当月的。
添加一周复选栏(复选框)并添加下面的公式。
=如果(WEEKNUMBER ((电子邮件保护)今天)= WEEKNUMBER (());1）
相同的版本，但为了您和其他人的方便，有以下更改。
=如果(WEEKNUMBER ((电子邮件保护)= weeknumber(今天())，1)
根据你的国家，你需要把逗号换成句点，分号换成逗号。要使用当前一周的筛选器，您应该选择通过Weekcheck列和选中复选框的位置进行筛选。
会工作吗?
祝你度过美好的一周!
最好的
她名叫Stara
工作流顾问@ Get Done咨询
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
谢谢你！抱歉，我只是不擅长公式。
我创建了新的Checkbox列。在同一栏中，我把公式写在下面
=IF(WEEKNUMBER([开始日期]1)= WEEKNUMBER(今天())，1)
似乎什么都没发生。这个复选框不应该被“选中”吗?
-
她名叫Stara ✭✭✭✭✭✭
乐意帮助!
看起来正确。尝试删除最后一个圆括号，以便Smartsheet可以尝试运行并自动修复它。如果这不起作用，您可以尝试再次选择Start Date单元格。
它工作了吗?
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
得到它!谢谢
一个。我有“合同日期”栏目的项目。我正在寻找一种方法，使用有条件的格式，使行红色是“合同日期”超过6个月，这样我就可以突出显示旧的工作。
单靠条件格式似乎做不到这一点。
-
她名叫Stara ✭✭✭✭✭✭
太棒了!
我总是很乐意帮忙!
是的,你可以。如果你在“设置条件”中选择一个日期列，你可以选择“是在最后(天)”，在那里你可以设置180天。
会工作吗?
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
这似乎适用于从今天到180天的日期。但180度或更大呢?不要在180天之前设置条件。
-
她名叫Stara ✭✭✭✭✭✭
这和“在(几天)以后”。选择。
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
当我使用
“Is in the last”(天)，把它改成180天。它突出了从今天到180天的所有事情。
当我使用
“在未来”(天)，设置为180，不设置任何条件，因为那是未来
不能让它突出显示过去超过180天的日期
-
她名叫Stara ✭✭✭✭✭✭
我的错误!
您可能需要一个辅助栏来完成此工作
如果我想了别的事情，我会再来找你的。
很抱歉混淆了。
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
保罗新来的 ✭✭✭✭✭✭thinkspi.com
-
她名叫Stara ✭✭✭✭✭✭
是的,当然。我太专注于条件句的部分了，我错过了。
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
完美的。谢谢大家
-
保罗新来的 ✭✭✭✭✭✭
-
保罗新来的 ✭✭✭✭✭✭
-
她名叫Stara ✭✭✭✭✭✭
乐意帮助!
最好的
她名叫
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
帮助文章资源欧宝体育app官方888
类别
Thanks for the suggestion, Michael! I made a slight tweak to the formula to ensure that an empty Due Date doesn't throw an error (as we want it to be blank), so this seems to be what is working for me:<\/p>
=IF([Project Type]@row = \"Review\", IFERROR(IF(NETWORKDAYS([Due Date]@row, [Actual Delivery Date]@row) < 0, NETWORKDAYS([Due Date]@row, [Actual Delivery Date]@row) + 1, IF(NETWORKDAYS([Due Date]@row, [Actual Delivery Date]@row) > 0, NETWORKDAYS([Due Date]@row, [Actual Delivery Date]@row) - 1)), \"//www.santa-greenland.com/community/discussion/comment/\"))<\/p>
Much appreciated!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-28 18:28:49","updateUser":{"userID":154338,"name":"RyanFMurphy","url":"https:\/\/community.smartsheet.com\/profile\/RyanFMurphy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!x1jQ8UirIZQ!W7ldX3b-ZDo!YO6bd86eyZo","dateLastActive":"2022-10-28T18:37:12+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"}]},{"discussionID":97104,"type":"question","name":"Check Box with multiple criteria","excerpt":"Hello - I am trying to get a checked box: If Column A value = Column B value, check box. However, I am also getting checked boxes when A and B are both blank which should not happen. Current formula is: =IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row), 1, 0)…","categoryID":322,"dateInserted":"2022-10-28T01:16:10+00:00","dateUpdated":null,"dateLastComment":"2022-10-28T13:34:26+00:00","insertUserID":154302,"insertUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T14:04:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154302,"lastUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T14:04:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3333885036,"url":"https:\/\/community.smartsheet.com\/discussion\/97104\/check-box-with-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97104\/check-box-with-multiple-criteria","format":"Rich","tagIDs":[254,437],"lastPost":{"discussionID":97104,"commentID":349118,"name":"Re: Check Box with multiple criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349118#Comment_349118","dateInserted":"2022-10-28T13:34:26+00:00","insertUserID":154302,"insertUser":{"userID":154302,"name":"Mark Muenzen","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Muenzen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T14:04:44+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-10-28T13:49:44+00:00","dateAnswered":"2022-10-28T02:09:57+00:00","acceptedAnswers":[{"commentID":349078,"body":"
Hey @Mark Muenzen<\/a> <\/p> The IF\/AND<\/strong> is only used when simultaneous conditions <\/strong>exist. IF the formula was only A=B, we would not use AND.<\/p> But since you found that an additional condition is needed in order to obtain the expected result, the formula becomes:<\/p> =IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row, [TRACcess Serial Number as Per TRACcess Manager]@row<>\"//www.santa-greenland.com/community/discussion/comment/\"),1)<\/p> The <> means 'is not'. The double quotes mean blank. The formula reads if [TRACcess Serial Number as Per TRACcess Manager]@row equals [TRACcess Serial Number As Reported by Tech]@row AND the [TRACcess Serial Number as Per TRACcess Manager]@row is not blank, then 1. If these are not true then the formula does nothing, which will leave the cell blank. <\/p> Does this work for you?<\/p> Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-28 13:49:44","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-28T17:07:07+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":97097,"type":"question","name":"What formulas should I use to count two criteria (including from a multiple dropdown option)?","excerpt":"I want to count \"Enrolled\" from \"Case Status\" AND \"Medicaid\" from \"Insurance Type.\" I used the COUNTIF formula, but it seems like Smartsheet isn't counting the Medicaid cell if it's within a cell with multiple criterias selected. Screenshots below: You can see that even though 2 fit the criteria, the sheet summary only…","categoryID":322,"dateInserted":"2022-10-27T20:52:45+00:00","dateUpdated":null,"dateLastComment":"2022-10-28T15:39:08+00:00","insertUserID":154291,"insertUser":{"userID":154291,"name":"pothosplant","url":"https:\/\/community.smartsheet.com\/profile\/pothosplant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T15:38:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154291,"lastUser":{"userID":154291,"name":"pothosplant","url":"https:\/\/community.smartsheet.com\/profile\/pothosplant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T15:38:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3333876713,"url":"https:\/\/community.smartsheet.com\/discussion\/97097\/what-formulas-should-i-use-to-count-two-criteria-including-from-a-multiple-dropdown-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97097\/what-formulas-should-i-use-to-count-two-criteria-including-from-a-multiple-dropdown-option","format":"Rich","tagIDs":[234,254],"lastPost":{"discussionID":97097,"commentID":349142,"name":"Re: What formulas should I use to count two criteria (including from a multiple dropdown option)?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/349142#Comment_349142","dateInserted":"2022-10-28T15:39:08+00:00","insertUserID":154291,"insertUser":{"userID":154291,"name":"pothosplant","url":"https:\/\/community.smartsheet.com\/profile\/pothosplant","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-28T15:38:45+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/3P7ZWW04TGQI\/countif-error-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"COUNTIF Error.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-28T15:45:44+00:00","dateAnswered":"2022-10-28T13:42:03+00:00","acceptedAnswers":[{"commentID":349120,"body":"
