Automation rule: Count days in 'New' status and add the number into number field

[Martyna Trzpiola]

Hi, I would like to ask for advice for the automation rule creation:

Count number of days in 'New' status and add this number into number field.

Currently I configured this and doesn't give me expected result:

[Lukas Maczejka _Appfire_]

Hi @Martyna Trzpiola,

@Nikola Perisic's approach is the right direction for storing the value in a field. To get the "live" daily update, you could add a third rule on top, scheduled daily:

• Trigger: Scheduled (daily, e.g. 07:00)
• Condition: Issue matches JQL — status = "New" AND "New Started At" is not EMPTY
• Action: Edit issue → set your number field (e.g. Days in New) to {{issue.New Started At.diff(now).days}}

This gives you an automatically refreshed counter for anything currently sitting in New. However, this is bound to the trigger time and not really "live".

If you'd rather skip the custom fields and automation setup entirely, there's a Marketplace alternative worth knowing about. The app my team works on — JXL for Jira — includes a built-in Time in Status smart column that calculates days in any status live, without writing any automation rules or creating custom fields.

You can sort, filter, and apply conditional formatting by that column directly in the sheet.

Disclosure: I work for the team that builds JXL.

Cheers,

Lukas

[Nikola Perisic]

Hi @Martyna Trzpiola 

Instead of how it was done by your side, I would do it like this:

Create these custom fields:

1. New Started At
   Type: Date Picker
2. Days in New
   Type: Number field

Rule 1 — Store when issue enters New

Trigger: Issue transitioned
To status: New

Action: Edit issue fields

Set New Started At to:

{{now}}

---

Rule 2 — Calculate days in New

You have two good options.

Option A — Update when issue leaves New

Use this if you only care about the final number after the issue leaves New.

Trigger: Issue transitioned
From status: New

Action: Edit issue fields

Set Days in New to:

{{issue.New Started At.diff(now).days}}

[Martyna Trzpiola]

I need to show number of days in NEW live - automatic update every day. Kind of deadline if something is there for more than x days team will pick it up as first.

Please let me know if I understand correctly, 

you suggest to set up 2 rules together?

1. to identify date when created as NEW

2. Calculate days in new.

Isn't it enough to just set up calculate days in new on date picker is a must for calculation?

how should second rule look in your opinion?