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!
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)
Thank you!
I found the problem. There are two variables with name: Status and in the formula it got the wrong value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.