How to write automation for calculated variable

surabhi_agrawal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 3, 2024

Hi Team,

I have three custom fields.
1. UAT due date
2. Actual Deployment date
3. SLA meet

SLA meet – This will be calculated variable:

If ‘Actual deployment date’ < ‘UAT due date’ - SLA meet value will be ‘Yes’

if ‘Actual deployment date’ > ‘UAT due date’ - SLA meet value will be ‘No’

Please suggest how to write automation for this.

2 answers

0 votes
Bill Sheboy
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.
April 3, 2024

Hi @surabhi_agrawal -- Welcome to the Atlassian Community!

First thing for your scenario, what happens if the dates are the same value: is the value set to yes or no?

 

Next, what have you tried thus far to solve this?

  • If you have a rule and it is not working, please explain what is not working as you expected, post images of your rule and the audit log details, and those will provide context for the community to offer suggestions
  • If you have not yet started a rule, I encourage you to try one. 
    • Successfully using automation requires learning and experimentation.  When one only implements rules created by others they will be unable to improve / maintain the rules. 
    • As a reminder, this is a community of users sharing ideas, learning, and seeking help.  It is not a free labor pool to implement requests upon demand.

To get you started on creating your rule, please refer to these documentation and example sources:

Kind regards,
Bill

0 votes
Marc Koppelaar
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.
April 3, 2024

Hi @surabhi_agrawal 

Welcome to the community.

This can be done by comparing the date fields and then setting the SLA meet value.

Example rule:

Screenshot 2024-04-03 at 14.57.21.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events