Possible? FILTER for "What's been done in the last two weeks" based on status change not dates

Suzanne Raphael

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?

Andrée Starå

Hi @Suzanne Raphael

I hope you're well and safe!

Yes, but you'd need to add a so-called helper column and then use a Workflow combined with the Record date Action to register the date it changes to Complete, and then you could have a filter/report showing what you need.

Make sense?

Would that work/help?

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

Suzanne Raphael

@Andrée Starå Thanks, as always, that works perfectly.

Cheers,

Suzanne

Andrée Starå

@Suzanne Raphael

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!