Custom formula to apply based on history of a field

Question

On our JDB, We have a field as Delivery Sprint and now we want to count how many times it's postponed, So we want to have a counter on it to add +1 to a field called "Pushed Sprint"

Now I added a formula to +1, But I don't want to add it when it was blank and we are not checking the allocated value.

Means after this value changes, I need to check if it was blank, do not add +1

Bill Sheboy · Answer

Have you confirmed that is the correct smart value for the field, Release Sprint?  If not, please do so before proceeding or the values will always be null.

Once you have confirmed the smart value, please remove issue from the changelog value.  For example:

Erfan Alvand · Answer

Thanks for reply @Bill Sheboy

I applied changes but still it's not working and not considering which it was blank or not! Seems it can not understand the field was blank or not...

Bill Sheboy · Answer

First, your trigger is on the "Release Sprint" field and so that is the only one available with the changelog within the rule.  The "Pushed Sprints" field did not change.

Next, please confirm you have the correct smart value for your field in the condition...

Smart values are name, spacing, and case sensitive, and they may not exactly match the field's display name on the Jira pages.  When the incorrect smart value is used, that evaluates to null and often fails to work as expected.

To find the correct smart value (or custom field id) for your field, please use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/