Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

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 May 05, 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

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Online AMA this week: Your project management questions answered by Jira Design Lead James Rotanson

We know that great teams require amazing project management chops. It's no surprise that great teams who use Jira have strong project managers, effective workflows, and secrets that bring planning ...

179 views 1 6
Read article

Atlassian Community Events