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; } } }

Time in Status in Structure Formulas

lradomsk

Hi,

Regarding structures and their formulas.

Is there a way to use "Time in Status" column value as a variable for formula calculations?

E.g. I want "Time in Status" to be multiplied by 2 and the result given in a dedicated column.

I did not find a direct equivalent in Expr language reference but maybe there's some tricks to do that?

Accepted answers

David Niro

Hello @lradomsk ,

At the moment it is not possible to reference Time in Status in another Formula.

We do have a task in our backlog related to this functionality and I have added your vote. I will follow up with you as soon as there is an update to share.

Best,
David

All comments

David Niro

Hello @lradomsk ,

At the moment it is not possible to reference Time in Status in another Formula.

We do have a task in our backlog related to this functionality and I have added your vote. I will follow up with you as soon as there is an update to share.

Best,
David

Stepan Kholodov

Hello @lradomsk

Now it is possible to reference complex variables in the Formula column, including the Time in Status column.
Please feel free ti try it and if you need any help - please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo

Megan_dbib63

can you let me know how? thanks!

Stepan Kholodov

@Megan

You just need to type the name of a variable in the Formula and select Time in Status on the dropdown list:
Screenshot 2023-12-06 at 10.11.29.png

Best regards,
Stepan

Richard.Donnell

I also found this useful - thanks - figured out its all in milliseconds

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

structure

addon-com.almworks.jira.structure

jira-software-server

time-in-status

expr

formula