Add :( to all issues which have been in particular status for over 2 weeks

[Kate McGladdery]

I've created a structure which shows how long each issue has spent in a particular status (called Discovery). I've used the 'time spent in status' attribute and that column is working fine. 

However, I'm looking to add an additional column to show if an issue has spent over 2 weeks in the Discovery status, show a :( face. Below is the current code I've used but it's not giving me what I'm looking for. 

Is anyone able to recommend what I need to change please :)

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Kate McGladdery 

The formula doesn't work because of the format of Time in Status values - although values appear in the column in days and hours, they are stored as timestamps internally. So if you want to reference a duration parameter, it should be defined as a timestamp in milliseconds too.

You can try a formula like this:
if timeindiscovery > 403200000 : ":("

You can check the timestamps by adding another Formula column with formula: timeindiscovery - this will show how values are stored.

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal, and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Kate McGladdery]

Thank you so much, works perfectly 😊