Can I create a Rule that triggers based on "Days In Column"?

Spencer Smith May 5, 2021

I would like to have an automated email which sends to an assignee after their "Days in Column" reaches a certain limit.  It would be nice having this feature, so that a gentle reminder can be sent instead of having to personally contact each person when a task hasnt been updated in a week.

How do I create a Rule that triggers based on the "Days in Column"?

1 answer

1 vote
Mikael Sandberg
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 5, 2021

Hi @Spencer Smith,

Welcome to Atlassian Community!

Days in Column is a calculation, it is not a function that you can use in a filter. But you could create a automation rule that looks at when the issue transitioned into a specific status and when it did it, something like this:

status = "In Progress" AND status changed to "In Progress" before "-5d"  

You could also check on when the issue was last updated like this:

status "In Progress" AND updated < -5d

Spencer Smith May 5, 2021

Thank you Mikael, 
That does sound like it should work. Ill give it a try and see what happens!

sandra_glaser April 5, 2023

Update to my previous comment: I rechecked what other options are cause I was 80% sure this will not work as I configured it before. 

So now it should work: image.png

Suggest an answer

Log in or Sign up to answer