How to write automation for calculated variable

Question

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.

Bill Sheboy · Answer

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:

* https://www.atlassian.com/software/jira/guides/automation/overview#what-is-automation
* https://www.atlassian.com/software/jira/automation-template-library#/rule-list?systemLabelId=all&page=1&pageSize=20&sortKey=name&sortOrder=ASC
* https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/

Kind regards,
Bill

Marc Koppelaar · Answer

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: