过滤器只显示本周的日期??
我正在为我们的建筑公司做一个项目进度表。
我希望能够有一个过滤器,只显示“开始日期”等于这个星期或这个月。
这可能吗?
评论
-
她名叫Stara ✭✭✭✭✭✭
你好,
是的,它是。
试试这个。
编辑更新了一个更简单的解决方案。
我的例子是针对本周的,但你也可以为这个月设置它。
添加一个weekcheck列(Checkbox)并添加下面的公式。
=如果(WEEKNUMBER ((电子邮件保护)) =周数(今天());1)
相同的版本,但有以下更改,以方便您和其他人。
=如果(WEEKNUMBER ((电子邮件保护)) =周数(今天()),1)
根据国家的不同,你需要把逗号换成句号,把分号换成逗号。要对当前星期使用过滤器,您可以选择根据Weekcheck列和复选框被选中的位置进行过滤。
这样行吗?
祝你一周愉快!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
vforte40 ✭
谢谢你!抱歉,我只是不擅长公式。
我创建了新的Checkbox列。在同一列中,我把公式写在下面
=IF(WEEKNUMBER([Start Date]1) = WEEKNUMBER(TODAY()), 1)
似乎什么也没发生。复选框不应该被“选中”吗?
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
看起来是对的。尝试删除最后一个括号,以便Smartsheet可以尝试运行并自动修复它。如果这不起作用,您可以尝试再次选择Start Date单元格。
奏效了吗?
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
vforte40 ✭
得到它!谢谢
一个。我有栏目“合同日期”的项目。我正在寻找一种方法,使用有条件的格式,使行红色是“合同日期”超过6个月,所以我可以突出显示旧的工作。
似乎您无法单独使用条件格式来完成此操作。
-
她名叫Stara ✭✭✭✭✭✭
太棒了!
我总是很乐意帮忙!
是的,你可以。如果你在“设置条件”中选择一个日期列,你可以选择“最近(天)”,然后你可以设置180天之类的东西。
这样行吗?
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
vforte40 ✭
这似乎适用于从今天到180天的日期。但是180度或更大呢?不要在180天前设定条件。
-
她名叫Stara ✭✭✭✭✭✭
这也可以用“在未来(几天)”选择。
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
vforte40 ✭
当我使用
“Is in last”(days),把它做成180天,它突出了从今天到180天的所有事情。
当我使用
"是下一个"(几天)然后设为180不设任何条件,因为那是未来
不能让它突出显示过去超过180天的日期
-
她名叫Stara ✭✭✭✭✭✭
我的错误!
您可能需要一个助手列才能使其工作
如果我想起来其他的事情,我会再打给你。
很抱歉造成了混乱。
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
保罗新来的 ✭✭✭✭✭✭
thinkspi.com
-
她名叫Stara ✭✭✭✭✭✭
是的,当然。我太专注于有条件的那部分,而忽略了那部分。
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
vforte40 ✭
完美的。谢谢大家
-
保罗新来的 ✭✭✭✭✭✭
-
保罗新来的 ✭✭✭✭✭✭
-
她名叫Stara ✭✭✭✭✭✭
很乐意帮忙!
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
Hi @Louis.Smith<\/a> <\/p> Maybe try this one:<\/p> =COUNTIF(Client:Client, \"Delta\")<\/p> I hope that helps.<\/p> Matt<\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106091,"type":"question","name":"How to reference column name pulled from formula","excerpt":"I'm trying to pull a date from columns based on the number in the helper column. I know I can do this with nested IFs, but is there a way to change which column I'm pulling the value from? My column Start Date should be whatever the column is based on the Index. So for the first column below, since Index is 3, it should…","categoryID":322,"dateInserted":"2023-06-06T19:01:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T19:24:57+00:00","insertUserID":162114,"insertUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162114,"lastUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3372158761,"url":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106091\/how-to-reference-column-name-pulled-from-formula","format":"Rich","lastPost":{"discussionID":106091,"commentID":379133,"name":"Re: How to reference column name pulled from formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379133#Comment_379133","dateInserted":"2023-06-06T19:24:57+00:00","insertUserID":162114,"insertUser":{"userID":162114,"name":"mwat4482","url":"https:\/\/community.smartsheet.com\/profile\/mwat4482","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T19:24:48+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\/EITIHXA4Y0I7\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:24:45+00:00","dateAnswered":"2023-06-06T19:18:07+00:00","acceptedAnswers":[{"commentID":379128,"body":" Are you trying to use that as a dynamic cell reference? If so, that is not possible. What it looks to me like you need is something more along the lines of<\/p> =INDEX([1st Date Column]@row:[Last Date Column]@row, 1, Index@row)<\/p> You are going to need to update the column names in the formula to match what you are using in your sheet.<\/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":[]},{"discussionID":106087,"type":"question","name":"Conditional Formatting Based on 2 Date Columns, with or without Helper Column","excerpt":"Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06\/29\/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06\/29\/2023 deadline,…","categoryID":322,"dateInserted":"2023-06-06T18:29:42+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162111,"lastUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":57,"score":null,"hot":3372157304,"url":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106087\/conditional-formatting-based-on-2-date-columns-with-or-without-helper-column","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":106087,"commentID":379120,"name":"Re: Conditional Formatting Based on 2 Date Columns, with or without Helper Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379120#Comment_379120","dateInserted":"2023-06-06T19:02:02+00:00","insertUserID":162111,"insertUser":{"userID":162111,"name":"Mlichtenstein","title":"Director","url":"https:\/\/community.smartsheet.com\/profile\/Mlichtenstein","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BtDbwegK_WQ!wlnbvxwzuT4!fyPHolHHR0X","dateLastActive":"2023-06-06T18:55: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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JWT4M72YQK8N\/screenshot-2023-06-06-142808.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-06 142808.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T19:00:34+00:00","dateAnswered":"2023-06-06T18:52:14+00:00","acceptedAnswers":[{"commentID":379113,"body":"
<\/p>