Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Structure formula for days overdue

Morvai Csaba February 13, 2024

Hi, 

I have problem with my formula. I want to show how many days late the issue but exclude the completed issues. I wrote this:

if targetend < now() AND status!="SAFE Completed":
DAYS_BETWEEN(targetend, NOW()) CONCAT " days late"

 

It displays the days correctly but do not exclude the completed issues. 

Thanks a lot!

2 answers

1 accepted

0 votes
Answer accepted
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 13, 2024

Hello @Morvai Csaba 

If the formula returns values for issues in the 'SAFE Completed' status, then please check the spelling and make sure that the Status is indeed called the same way as you reference it in the formula. You can add another Formula column with formula: status to see what value is actually being returned and reference it to exclude issues. 

If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)


0 votes
Morvai Csaba February 13, 2024

Thank you!

 

I found the problem. There are two variables with name: Status and in the formula it got the wrong value.

 

 Screenshot (39).png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events