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; } } }

Jira smart values for custom field: calculate and log work not working

toannv26

I define a rule to auto log work when user change effort value.

Step 1: Calculate the diffday difference when the developer actual effort field (customfield_19616) changes by subtracting the old value (stored in the customfield_10303 field.because fieldchange.from.value cannot be used). The unit of this field is days.

smart values:
{{#=}}{{issue.fields.customfield_19616.diff(issue.fields.customfield_10303).abs}}{{/}}

Step 2: Convert diffday to hours and store it in the log work field.
smart values: {{#=}}{{diffday}} * 8{{/}}h

Step 3: Store the value of the developer actual effort field in the program_id field to calculate the difference next time.

Smart Value:
{{issue.fields.customfield_19616}}

I try many way but seem it not work. This log show bellow
I'm using Jira v9.12.10

Please help me

Accepted answers

toannv26

Hello @Trudy P Claspill , @Bill Sheboy , @Duc Thang TRAN
I found the correct rules for this case. Because the value seem have special character, so can't using math function directly.

This is my worked rule:
{{#=}}{{issue.customfield_19616.plus(0)}} - {{issue.customfield_10303.match("(\d+\.?\d*)")}}{{/}}

Thank you all for support

All comments

Trudy P Claspill

Hello @toannv26

Welcome to the Atlassian community.

I suspect there may be a problem with your use of the diff function in the math expression you use when creating your {{diffday}} variable.

Can you add a Log action after creation of that variable to log the value of it?

Screenshot 2025-12-14 at 9.58.33 PM.png

I suspect this is the case because no value is being shown for the variable in the error message in your log. Instead it is detecting the "*" as the first character in that match expression.

Screenshot 2025-12-14 at 10.01.56 PM.png

I think instead of the diff function you need to use the unary minus operator to subtract one value from the other.

Disclaimer: I don't have a Data Center environment where I can test this out, so this is an untested recommendation.

toannv26

@Trudy P Claspill Thank you for your support. I think you are right about diff value issue. I change to minus operator but it still not working
Screenshot 2025-12-15 131728.png

Duc Thang TRAN

Hello @toannv26

Can you try this smart value if you need diff business days ?
{{#=}}{{issue.fields.customfield_11206.diff(issue.fields.customfield_11256).businessDays.abs}}*8{{/}}

If only need diff day

{{#=}}{{issue.fields.customfield_11206.diff(issue.fields.customfield_11256).days.abs}}*8{{/}}

Hope this can help

Trudy P Claspill

What are the custom fields types for 19616 and 10303?

Consider logging the values of those fields, and the math expression from your Create Variable, into the audit log to see if you are getting the expected values

toannv26

@Trudy P Claspill
customfield_19616 type float, customfield_10303 type text
I try to convert text tonumber but not working

{{#=}}{{issue.fields.customfield_19616 - issue.fields.customfield_10303.asNumber}}{{/}}

toannv26

customfield_19616 type float, customfield_10303 type text
It not a date field. So I think .days or .businessDays will not working

Duc Thang TRAN

Hello @toannv26

When I suggest this, I think you used beetwen two date fields.

If one is a float or text field, you can try this one: {{#=}}(ABS({{issue.fields.customfield_19616}} - {{issue.fields.customfield_10303}})*8){{/}}

toannv26

Hello @Trudy P Claspill , @Bill Sheboy , @Duc Thang TRAN
I found the correct rules for this case. Because the value seem have special character, so can't using math function directly.

This is my worked rule:
{{#=}}{{issue.customfield_19616.plus(0)}} - {{issue.customfield_10303.match("(\d+\.?\d*)")}}{{/}}

Thank you all for support

Duc Thang TRAN

Hello @toannv26

Indeed, if you have a free-text field and people enter characters other than numbers, this is normal .astext retrive error

For my suggestion , it is better to use a date field and let the smart value handle the difference, which helps avoid errors when inserting data

Welcome!

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

Quick Links

Find more posts tagged with

automation

smart-value

log-work