nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smart values in automation - formatting

Dd_ccz4b8

Hi,

I have a custom field - cycle which is a single list select,

It's values are the 2 last digit of a year and a sequential number (week number divided by 2).

For example, possible values:

25-07
26-15

I would like to use a manual trigger in automation that when I run it, a that cycle field gets populated by the last 2 digits of the current year and the week number padded to 2 digits (so I don't get 25-9 but rather 2509

What I do know is:

now.format("yy") - will probably give me the year's last 2 digits (is that correct)
{now.format("w").LeftPad(2,"0")}

How can I make the above happen?

Divide the week number by 2 rounded up
Set the value of cycle to be the concatenation of all.

The current automation:

Screenshot 2025-08-27 100024.png

Thanks

Accepted answers

Bill Sheboy

Hi @Dd

For a question like this, context is important for the community to help. Please post the following:

an image of your complete automation rule in a single image for continuity
images of any relevant actions / conditions / branches
an image of the audit log details showing the rule execution
explain what is not working as expected and why you believe that to be the case

Until we see those...

When you tried putting those expressions together, what did you observe happening?

You are asking how to build the value for a selection field, and so that likely needs to be built and stored in a Created Variable, and then use JSON to make the selection. Doing it that way will allow incrementally building the result and checking progress...And, validating your assumptions. (For example, you describe dividing the week by 2 and rounding down, and so should the value for 1 be week 00?)

Here is an example that will produce that value with date, text, and math functions, assuming the value of 00 for the week is acceptable.

{{now.format("yy")}}-{{now.format("w").asNumber.divide(2).format("00")}}

Kind regards,
Bill

All comments

Pedro Olmo_7tm5vp

Hello @Dd ,

I would, for example, try splitting that field as in the screenshots I attached from the issue.key, so you can keep the first value and the last one. With those two variable values, you can then combine them into one.

Captura de pantalla 2025-08-26 103948.png

Captura de pantalla 2025-08-26 104026.png

Edit field with two values:

Captura de pantalla 2025-08-26 104136.png

Regards

Duc Thang TRAN

Hello @Dd

For Week divide by 2

{{#=}}{{now.weekOfYearIso}} / 2 {{/}}

For year with 2 digits and exclude 0 for exemple 2009

So combine 2 sections i think is

{{#=}}{{now.weekOfYearIso}} / 2 {{/}} - {{now.format("yy").replaceAll("^0","")}}

Hope this can help

Bill Sheboy

Hi @Dd

For a question like this, context is important for the community to help. Please post the following:

an image of your complete automation rule in a single image for continuity
images of any relevant actions / conditions / branches
an image of the audit log details showing the rule execution
explain what is not working as expected and why you believe that to be the case

Until we see those...

When you tried putting those expressions together, what did you observe happening?

Here is an example that will produce that value with date, text, and math functions, assuming the value of 00 for the week is acceptable.

{{now.format("yy")}}-{{now.format("w").asNumber.divide(2).format("00")}}

Kind regards,
Bill

Dd_ccz4b8

You are correct - I need to start from 1 (my bad). Is there a way to round up?

While waiting for a reply - I'll run the above and post all requested based on that (to be honest - it's a manual trigger and the smart values I tried were so far - I assume that is irrelevant)

Thanks

Dd_ccz4b8

Tried the above - go the following (I hate JSON)

Screenshot 2025-08-27 100125.png

I probably miss some bracket ...

Dd_ccz4b8

I'll try - thanks

Dd_ccz4b8

I'll try. Thanks

Bill Sheboy

First for the error you see, there is an extra left-curly bracket in there. As a tip, I recommend writing stuff like this in an external editor which shows pairing for parentheses, brackets, etc.

Next for the rounding: this cannot be done with the inline math, as that is using integer math because the week number is an integer...and thus loses the fractional part.

We can change that second part to use a long-format math expression with the ROUND function.

{{now.format("yy")}}-{{#=}}ROUND( {{now.format("w")}} / 2, 0 ){{/}}

But now we have a formatting problem. The fix, as often is the case, is Created Variables. That will also avoid any timing problems building the JSON.

action: create variable
- name: varYear
- smart value: {{now.format("yy")}}
action: create variable
- name: varQuarter
- smart value: {{#=}}ROUND( {{now.format("w")}} / 2, 0 ) {{/}}
action: create variable
- name: varYearQuarter
- smartValue: {{varYear}}-{{varQuarter.asNumber.format("00")}}
then use {{varYearQuarter}} in the JSON

Pedro Olmo_7tm5vp

Hello @Dd ,

Doesn’t it work for you with the split on the custom field?
It should let you grab the first value before the “-” and the last one. With those two variables, you can then concatenate them into the field you need.

If you need anything else, just let me know here.

Regards

Duc Thang TRAN

Something like that @Dd
During the test, I'm using a date-time field then get information: week number divided by 2, and the year in 2 digits.
In exemple : Jun 12, 2007, 2:00 AM
Then edit the Equipe (select list). You need to create all values as needed. Here is the config and audit log

2025-08-28 10_42_09-Rule builder - Automation - Admin Jira - Test - Jira — Mozilla Firefox.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud