Time in Status in Structure Formulas

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?

2 answers

1 accepted

2 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

can you let me know how? thanks!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

@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