Filter to show only dates from this week???

Andrée Starå · 12/11/18

We are only human!

Rob L · 08/19/20

Looking at this topic as it would help me a lot.

I tried to paste the formula in my 'Check box' column:

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

Unfortunately I get the error 'UNPARSEABLE'. I live in SG, so I tried the other formula as well, but both gave the same error. Are you able to assist? Thanks!

Andrée Starå · 08/21/20

Hi@Rob L

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s)or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jaye Casciano · 01/07/22

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-08-22T19:33:12+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

So sorry to resurrect an old post@Andrée Starå. Have you ever figured out how to do this from the report side? I have a feeling it's not possible without a helper column in the target sheet but alas I don't own the target sheet in my situation and cannot add a column to it. I need a way to run a report that pulls only rows from the target sheet that have dates the same week as "today". Figured you'd be a good person to ask! :)

Suzanne Raphael · 04/07/22

I doubt this is the best place for this question, but it is related. I have a Status column with dropdown options that includeComplete. 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."

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

Thanks!!!!!

Genevieve P. · 04/11/22

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-07-28T13:24:18+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

Hi@Suzanne Raphael

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!

See:Set the current date with the Record a Date action

Cheers,

Genevieve