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?

[David Niro · Accepted solution]

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 (Tempo)]

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]

can you let me know how? thanks!

[Stepan Kholodov (Tempo)]

@Megan 

You just need to type the name of a variable in the Formula and select Time in Status on the dropdown list:


Best regards,
Stepan

[Richard_Donnell]

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