Error for In Progress & defined status in structure formula

Question

Hello All,

I wanted to highlight the remaining estimates  to my team, for which i wanted to use formula..

Please correct me

IF(

status= complete and (time_spent -orginal_estimate)=0; "done";

status = In_progress and (time_spent -orginal_estimate)>0; "Burn";

status = Define and (remaining_estimate - orginal_estimate )=0 "Start")

In progress and Define are giving errors.

Dionathan Lopes {ALM Works} · Answer

Hello Shyam Since the formula looks good and there are no error messages returned, it appears that the issues do not meet the criteria of the formula.   These are the items you will want to check:a) Do the statuses "done", "in_progress", "define" match what is being used in your project & are the issues in your structure set to these statuses

b) Do the issues in your project match the criteria that it is in the Status AND match the time requirements you have defined.

c) Double-check that the Variables you have mapped (status, time_spent, original_estimate & remaining_extimate) are mapped to the fields being used in your Jira issue.

We would be happy to help you check these things over a screen-share session.  Please send us an email to support@almworks.com and we can get one set up!
All the best,
Dionathan L
www.almworks.com

shyam prasad_p2uju6 · Answer

Hi dionathan,

Thank you very much for the replay, I have added that code but i am not able to see anything in formula column. Please let me know if i need change anything.

Dionathan Lopes {ALM Works} · Answer

Hello Shyam,

Thank you for sharing your Structure Formulas question here on the Atlassian Community

You could try the below formula and see if it works:

IF(
status = "DONE" and (time_spent - orginal_estimate) =0; "Done";

status = "IN_PROGRESS" and (time_spent - orginal_estimate) >0; "Burn";

status = "DEFINE" and (remaining_estimate - orginal_estimate) =0; "Start")

Please refer to this article for more information - LINK

Please let me know if it helps and don't hesitate to contact us if you need any further assistance.

Best Regards,
Dionathan Lopes
[ALM Works]