nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

smart value

Ivan Andrieiev_2jlshw

There is a task to calculate how much time has passed from filling one hour field to another. I'm using automation in Jira, but the field I've created isn't getting populated under the right conditions.
{{TimeCandidate}} = {{[Planned Start Date].diff([Planned End Date]).[days]}}
or the new TimeCandidate variable
and in the formula line {{[Planned start date].diff([Planned end date]).[days]}}

Accepted answers

Gaurav_0av1h6

Hello @Ivan Andrieiev

Please try the below formula, which works for me.

Here I am using it for the default Jira fields Planned start and Planned end.

Kindly let me know if this works or if you have any further queries.

Please accept the answer if this helps.

--GG

Gaurav_0av1h6

Hello @Ivan Andrieiev

Kindly elaborate on the new use case, enabling me to provide a better-customized solution.

--GG

All comments

Gaurav_0av1h6

Hello @Ivan Andrieiev

Please try the below formula, which works for me.

Here I am using it for the default Jira fields Planned start and Planned end.

Kindly let me know if this works or if you have any further queries.

Please accept the answer if this helps.

--GG

Ivan Andrieiev_2jlshw

@Gaurav Hi

Planned start and Planned end. Are these custom fields created?

Gaurav_0av1h6

Hello @Ivan Andrieiev

These are not custom fields. The Planned end and Planned start are default Jira fields.

Let me know if you need help with custom fields.

—GG

Ivan Andrieiev_2jlshw

In the automation settings, it says success, but I don't see the result that would count the days from the start date to the end date.

Gaurav_0av1h6

Hello @Ivan Andrieiev

Kindly elaborate on the new use case, enabling me to provide a better-customized solution.

--GG

Ivan Andrieiev_2jlshw

@Gaurav Hi

Condition of the problem
We have a created vacancy and its creation date.
For example "job creation date"
We are creating a task in our recruitment project and will write this date in this field.
There is a vacancy closing date (vacancy closing date), it will be set only in one task before the task changes to the "Accepted" status, in tasks with a "Rejection" status, it will not be set.
I need to know how many days this vacancy has been open.

Gaurav_0av1h6

Hello @Ivan Andrieiev

If I understand the ask, you need to know how many issues are in 'Open' status. For such issues, you can create a filter and make use of that.

Please let me know if you need help with the JQL for creating the filter.

--GG

Ivan Andrieiev_2jlshw

@Gaurav

The system is the same, I just need it to count the days not immediately, but only when another date is set.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud