Formula to calculate the time since item was moved to a group

Platform discussions
, ,
1

Hey!

I am trying to add two columns in my board that will contain the number of days (int) and the time (datetime) since an Item was moved from one group to another.

For example:

A feature request was opened under a group - ‘New requests’ on Feb 1st, 24 then the item was moved to group - ‘Planned’ on Feb 5th, 24, finally the item was moved to ‘Released’ on April 1st, 24.

Then the column of ‘Days to Release’ will be - 60 days (from the creation date to the ‘Release’ date).
And the date column will be the date it was moved to ‘Released’ which is April 1st,24.

Is there a way I can do such a thing?

Thanks!

2

Hi Idan,

If I understand your requirements correctly, all you have to do is create an automation that reads “When item is moved to group “X”, Set {date} to today”

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

1 Like