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

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!