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, andree@getdone.se)

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 by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

JLC · 01/07/22

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 include Complete. 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

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

Suzanne Raphael · 04/11/22

https://community.smartsheet.com/discussion/comment/325649#Comment_325649

Thanks a bunch, that is exactly what I needed.

Cheers,

Suzanne

Filter to show only dates from this week???

Comments

Help Article Resources

Categories