I'm wondering if there's a way to somehow alert on "stale" items.
My usage case here is that we've moved some defects to a "blocked" status if they need more analysis/further decisions prior to fixing them. Sometimes we forget about these defects, and have had some sit for weeks with no updates. I'd like a way to notify someone (e.g. via the RSS feed) when something hasn't been updated in awhile.
Per the thread on "alert on new comment," I find it unlikely this is supported directly, but if it is please let me know.
I was thinking I could "hack" this somehow by putting a formula property on cards like "Today-LastUpdateDate", putting in a transition that resets "LastUpdateDate" to today and requires a comment, and setting up alerts when "TimeSinceLastUpdate" changes to something greater than 7. Then I get an e-mail for blocked defects if someone hasn't "hit the snooze button" and added a comment in the last week.
This seems like a terrible hack, and I don't think it would actually work (I don't believe I can use "today" in a formula property, unless I make it a project value and update it every day...). Anyone have better (preferably working) ideas?