i am not getting the value in the custom field of showing none

[Abdul Subhani Shaik]

when i run a automation its showing the issue edited successful but not getting the value. showing none.

i had used the format

[Gaurav Arora]

Hi @Abdul Subhani Shaik 

Please share the complete smart value you are entering in field. And also confirm the field types of "customfield_10623" and "T-Under decision analysis".

BR,

Gaurav

[Tomislav Tobijas _Koios_]

Hi @Abdul Subhani Shaik ,

Can you maybe share which type field "T-Under decision analysis" is? Is it a text field, data field or something else? Also, what field is this customfield_10623?

Also, I would suggest using Log action within the rule to see what this smart value you've used is actually returning. Something like this but with complete smart value:

Also, it would be quite helpful if you could share a complete automation rule screenshot and audit log once you run it (with Log action added). On top of everything, a short description of the use case (what you're trying to do) could provide some additional light on everything.

Cheers,
Tobi

[Abdul Subhani Shaik]

hi,

 i need two status in days one is created and another when staus change.

i had created a custom field as a number field that field having a value of {{now.diff(issue.created).days}}. Now, i am using the custom field in another status as

{{now.diff(issue. Customfeild)days}}. its running successful but its not giving value. Just showing None. Plz help me out this.

Thanks,

Subhani.

[Tomislav Tobijas _Koios_]

Hi @Abdul Subhani Shaik ,

If I understood it correctly, you have 2 custom fields (number type) where in each you would like to store the 'days in status' value.

For example:

1. Number field #1 = when issue is transitioned, calculate the difference between now and issue created time
2. Number field #2 = when issue is again transitioned, calculate the difference between now and last transition date

One note is that .diff() function works when you have two dates, and in your case we're talking about one date and one number field.

What you could probably do (this just came on top of my mind) is the following - use math functions for the custom field to calculate the difference:

• Custom field #1 = {{now.diff(issue.created).days}}
• Custom field #2 = {{#=}}{{now.diff(issue.created).days}} - {{issue.customfield_1}}{{/}}

Basically, you would just calculate the difference between now and the issue created, and then subtract a number of days between the first transition and the issue created. I didn't test it out but I guess this is something that could work.

Additionally, I would recommend checking the following documentation/guide for calculating time spent in each status: How to calculate the time spent on each status and total time on the issue 

Note that there may be some better/more optimal solution.

Cheers,
Tobi