adjust the [Days in Column]

Shiva March 24, 2022

Hi,

[Days in column] is a default calculated column in our Kanban Board.

i have a existing automation. What i want is, that it should reduce [Days in Column] to ZERO when it runs.

 

Is this possible? i cannot find the field [Days in Column] when trying to create a automation. So that means i need to implement i manually. probably like:

 

{
"fields": {
"Days In Column": 0
}
}

 

it this correct?

 

2 answers

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 24, 2022

Hi @Shiva Ajodhia 

Would you please clarify what problem you are trying to solve?

It would appear you have a custom field called "Days in Column"...or...are you referring to the built-in "Days in column" setting for a board showing the dots for time indication: 

Show a visual indicator on each card that represents the time spent in the column. This can help identify slow moving issues.

Kind regards,
Bill

Shiva March 28, 2022

@Bill Sheboy- im referring to the built-in "Days in column" setting for a board showing the dots for time indication.

Trudy mentioned she already checked if its possible to reset it, but it did not work. thats unfortunate.. but at least i have a answer to work with

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 28, 2022

Thanks for that information. 

Other than teams using a simple workflow (with no moving backwards in flow), we often ignore that feature.  Instead we use an actual Age Of WIP custom field set with automation.  That seems more valuable than knowing the time in a board column which may contain multiple, mapped status values.  When we need actual "time in status" for cycle time calculations we use the Atlassian interpretation of a "control chart" or marketplace addons for reporting.

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 24, 2022

Days In Column is not an editable field. The information is derived in real time and presented on the board.

I was going to suggest that you could reset its value by moving it to another column and then back to the original column, but I just tested that and it does not actually reset the value.

Jeret Shuck February 29, 2024

moving it to another column and then back to the original column, but I just tested that and it does not actually reset the value.

This. This is exactly what I was hoping this feature did. I'd like that value reset to zero, once it's moved into a new column.

Suggest an answer

Log in or Sign up to answer