Structure formula for days overdue

[Morvai Csaba]

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!

[Stepan Kholodov (Tempo) · Accepted solution]

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)

[Morvai Csaba]

Thank you!

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