过滤器只显示本周的日期??

她名叫Stara

我们只是凡人!

罗伯·L

嗨@Andree Stara

看看这个话题，因为它会帮助我很多。

我试着将公式粘贴到我的“复选框”栏中:

=如果(WEEKNUMBER ((电子邮件保护)) =周数(今天())，1)

不幸的是，我得到错误'UNPARSEABLE'。我住在SG，所以我也试了另一个公式，但都给出了同样的错误。你能帮忙吗?谢谢!

她名叫Stara

嗨@Rob L

我很乐意快速看一下。

你能更详细地描述一下你的过程吗?也许可以分享一下这些表格/表格的复印件。或者一些截图?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护)）

我希望这对你有帮助!

注意安全，周末愉快!

最好的

她名叫Stara|工作流程顾问/ CEO @工作大胆

✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的。这将使其他人更容易找到解决方案或帮助回答!

Jaye Casciano

Hi,<\/p>\n

Yes, it is.<\/p>\n

Try this.<\/p>\n

Edit<\/strong>: Updated with a simpler solution.<\/p>\n

My example is for the current week, but you could set it up for the month as well.<\/p>\n

Ad a weekcheck column (Checkbox) and add the formula below.<\/p>\n

=IF(WEEKNUMBER(Start@row) = WEEKNUMBER(TODAY()); 1)    <\/p>\n

The same version but with the below changes for your and others convenience.    <\/p>\n

=IF(WEEKNUMBER(Start@row) = WEEKNUMBER(TODAY()), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.<\/em><\/p>\n

To use the filter for the current week, you'd choose to filter by the Weekcheck column and where the checkbox is checked.<\/p>\n

Would that work?<\/p>\n

Have a fantastic week!<\/p>\n

Best,<\/p>\n

Andrée Starå<\/p>\n

Workflow Consultant @ Get Done Consulting<\/p>","bodyRaw":"

Hi,<\/p>\n\n

Yes, it is.<\/p>\n\n

Try this.<\/p>\n\n

Edit<\/strong>: Updated with a simpler solution.<\/p>\n\n

My example is for the current week, but you could set it up for the month as well.<\/p>\n\n

Ad a weekcheck column (Checkbox) and add the formula below.<\/p>\n\n

=IF(WEEKNUMBER(Start@row) = WEEKNUMBER(TODAY()); 1)    <\/p>\n\n

The same version but with the below changes for your and others convenience.    <\/p>\n\n

=IF(WEEKNUMBER(Start@row) = WEEKNUMBER(TODAY()), 1)
\nDepending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.<\/em><\/p>\n\n

To use the filter for the current week, you'd choose to filter by the Weekcheck column and where the checkbox is checked.<\/p>\n\n

Would that work?<\/p>\n\n

Have a fantastic week!<\/p>\n\n

Best,<\/p>\n\n

Andrée Starå<\/p>\n\n

Workflow Consultant @ Get Done Consulting<\/p>","format":"html","dateInserted":"2018-12-11T07:18:12+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-07T07:19:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/121691#Comment_121691","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/121691#Comment_121691

很抱歉要重提一个旧帖子@Andree Stara。你有没有想过如何在报告端做到这一点?我有一种感觉，这是不可能没有一个辅助列在目标表，但唉，我不拥有目标表在我的情况下，不能添加一列。我需要一种方法来运行一个报告，仅从目标表中提取行，其日期与“今天”相同。我觉得应该找你谈谈!:)

苏珊娜拉斐尔

我怀疑这是不是回答这个问题的最佳地点，但它是相关的。我有一个状态列与下拉选项，包括完整的。我也有开始/结束日期，但IRL的东西可能会落在这些日期之外，或者在这些日期之前，所以它们对我需要的东西并不真正有用，这是一个过滤器，“上周做了什么;过去两周。”

因此，我需要一个过滤器来查看Status列何时更改为Complete。作为保存的、可共享的过滤器，这可能吗?

谢谢! !

吉纳维芙P。

I doubt this is the best place for this question, but it is related. I have a Status column with dropdown options that include Complete<\/em>. I also have start\/end dates, but IRL stuff may fall out of those or ahead of those, so they aren't really useful for what I need, which is a filter for "What's been done in the last week; the last two weeks." <\/p>

So I need a filter that looks at when the Status column changed to Complete. Is this possible—as a saved, sharable filter?<\/p>

Thanks!!!!!<\/p>","bodyRaw":"[{\"insert\":\"I doubt this is the best place for this question, but it is related. I have a Status column with dropdown options that include \"},{\"attributes\":{\"italic\":true},\"insert\":\"Complete\"},{\"insert\":\". I also have start\\\/end dates, but IRL stuff may fall out of those or ahead of those, so they aren't really useful for what I need, which is a filter for \\\"What's been done in the last week; the last two weeks.\\\" \\nSo I need a filter that looks at when the Status column changed to Complete. Is this possible—as a saved, sharable filter?\\nThanks!!!!!\\n\"}]","format":"rich","dateInserted":"2022-04-07T21:23:29+00:00","insertUser":{"userID":96241,"name":"Suzanne Raphael","url":"https:\/\/community.smartsheet.com\/profile\/Suzanne%20Raphael","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-06T18:07:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/325443#Comment_325443","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/325443#Comment_325443

嗨@Suzanne拉斐尔

您可以使用“记录日期”工作流来自动记录您的状态更改(在新的“日期”列中)。然后，您可以将Date列用于过滤器!

看到的:使用“记录日期”操作设置当前日期

欢呼,

吉纳维芙

苏珊娜拉斐尔

https:\/\/community.smartsheet.com\/discussion\/comment\/325443#Comment_325443<\/a><\/p>

Hi @Suzanne Raphael<\/a> <\/p>

You can use a Record a Date workflow to automatically record when your Status changes (in a new Date column). Then you can use that Date column for your filter!<\/p>

See: Set the current date with the Record a Date action<\/a><\/p>

Cheers,<\/p>

Genevieve<\/p>","bodyRaw":"[{\"insert\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/comment\\\/325443#Comment_325443\",\"attributes\":{\"link\":\"https:\\\/\\\/community.smartsheet.com\\\/discussion\\\/comment\\\/325443#Comment_325443\"}},{\"insert\":\"\\n\"},{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Suzanne Raphael\",\"userID\":96241}}},{\"insert\":\" \\nYou can use a Record a Date workflow to automatically record when your Status changes (in a new Date column). Then you can use that Date column for your filter!\\nSee: \"},{\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/articles\\\/2481986-set-the-current-date-with-record-a-date-action\"},\"insert\":\"Set the current date with the Record a Date action\"},{\"insert\":\"\\nCheers,\\nGenevieve \\n\"}]","format":"rich","dateInserted":"2022-04-11T09:18:39+00:00","insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-06T21:50:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/325649#Comment_325649","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/325649#Comment_325649

非常感谢，这正是我所需要的。

欢呼,

苏珊