Smart Value for Future Quarter tickets

[Erica Robinson]

Background: We have approx 30+ tickets that are build out each quarter that have Q{{now.format("Q")}} built into them since they're quarter specific. These are for various different teams that I help organize automations for.

I was asked to have some of the tickets made ahead of the quarter start so they can start to be scheduled into the future sprints. I've tried the following, but both just give me Q with no quarter value:

• Q{{now.plusMonths(1).startOfMonth("Q")}}
• Q{{now.plusWeeks(2).startOfWeek("Q")}}

Essentially I'm trying to create a ticket in the current quarter (Q2) for the next quarter (Q3) and I need the ticket to read "Ticket Summary Q3" not "Ticket Summary Q2" once it's created. 

We are not looking to add any plug-ins for this functionality. If it's not available via smart value then I will advise the individuals accordingly.

[Bill Sheboy · Accepted solution]

Hi @Erica Robinson -- Welcome to the Atlassian Community!

Please continue to use the format() function for that, incrementing the date, as needed.

For example:

Q{{now.plusMonths(1).startOfMonth.format("Q")}}

or this one, to automatically add the Q:

{{now.plusMonths(1).startOfMonth.format("qqq")}}

Please look here to learn more possible formats:

• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---
• https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

Kind regards,
Bill

[Erica Robinson]

Thanks for the welcome @Bill Sheboy! :) 

These both worked perfectly! Thank you so much, this is going to save a lot of time for me and my teams.