Automation: Automatically copy Sprint End Date to planned End Date when added or changed.

Question

I am attempting to create an automation that will automatically populate the 'due date' and the Planned End Date with the Sprint End Date for that issue when the Sprint is added or changed. I have tried all of the formulas below and I either get nothing, I get the date of the last sprint created but if I chose any other sprint I get "Jan 01, 2024" or one of the errors below:

Trigger:

When value changes for the Sprint field -->

Planned End Date:

{{Issue.Sprint.endDate.min}} --> Does not work due to format

Planned End Date:

{{Issue.Sprint.endDate.max}} --> Does not work due to format

The format it is: 07/Jan/24 7:00 PM

And I tried these formulas but neither didn't work, I have them with the error messages.

{{issue.sprint.startDate.min.format("dd/mm/yy h:mm AM/PM")}}
EDIT ISSUE

Error rendering smart-values when executing this rule:
Failed to get value for issue.sprint.startDate.min.format("dd/mm/yy h:mm AM/PM"): {{issue.sprint.startDate.min.format("dd/mm/yy h:mm AM/PM")}}

{{issue.sprint.startDate.min.format("dd/mmm/yy h:mm AM/PM")}}
EDIT ISSUE
Error rendering smart-values when executing this rule:
Failed to get value for issue.sprint.startDate.min.format("dd/mmm/yy h:mm AM/PM"): {{issue.sprint.startDate.min.format("dd/mmm/yy h:mm AM/PM")}}

EDIT ISSUE

Error editing issuesDIST-10826 (Check the format of Planned start (customfield_10135), Check the format of Planned end (customfield_10136))

Kalyan Sattaluri_iinm1n · Answer

I am surprised why it did not work when directly assigning. But glad you got this done!

KAIA STRICKLAND · Answer

@Kalyan Sattaluri I got it!! I put the formula in "Additional fields" and it worked!

Kalyan Sattaluri_iinm1n · Answer

OK, lets try this as well please.. :p