Automation to divide date custom field based on actual efforts in percentage

Question

Hi Team,

I am using Automation in Jira Cloud for my project purpose. Could you please on below requirement:

1) I have date custom field Planned Live date, Actual effort in percentage(number), Actual effort in days(number) and status (single select list) with Values Red, Orange, Green and would like to create Automation rule for same.
2) I am facing issue to create Automation rule using smart values for below requirement:

* if Jira issue crossed planned Live date if Actual effort in percentage is b/w 1-19.99%, status must be in Orange.
* else if Jira issue crossed planned Live date if Actual effort in percentage is 20 to 30%, status must be in Red.
* else Jira issue completed within  planned Live date if Actual effort in percentage is 0 status must be in Green.

Any help would be appreciate?

BR,

Sattar

Yoann LEGRAND_s0mdft · Answer

Hi @Sattar Baig ,

Can you try this  :  {{#=}}{{now.diff(Planned Go-Live Date).days}} / 100{{/}

Sattar Baig_st2bvj · Answer

Hi @Marco Brundel

I got requirement from my team they would like to see how much percentage Jira issue got completed like 10%,20% based on Planned Go-Live date(date field). But my team is facing issue they have to enter manually percentage value on Actual effort in percentage field by calculating on their own. Specifically, I am looking for Automation rule for my below requirement:

we have below custom fields in my project:

Planned Live date(date field),

* Actual effort in percentage(number), 
* Actual effort in days(number) and 
* status (single select list) with Values Red, Orange, Green

My requirement is:

* Example: if Planned Go-Live date is 30-8-23, Actual effort in percentage must calculated as 0, status will be green.
* Example:if Planned Go-Live date is 13-8-23, Actual effort in percentage must calculated as in between 1-20%, status will be Orange.
* Example: if Planned Go-Live date is 20-07-23, Actual effort in percentage must calculated as more than 20-40%, status will be Red.

Could you please help me to how to create automation rule for above requirement?

I have created automation rule for one field Actual effort in Percentage field using smart values in automation

But automation rule is calculating as 0 and it's not working according to my expectation.

Could you please help with this?

Please find the attached screenshot for reference....

Marco Brundel · Answer

Hi @Sattar Baig ,

Sorry, I don't see a solution for you right away.

I personal don't understand on what basis you want the percentage. In what situation is it 100%?

And what specific error do you get on the smart value in Automation?

regards, Marco