Changing date on item when it's moved to a different group

[Keira_REZ (Keira Francis)]

I’m setting up a board where I want to be able to move items between groups.

When I move an item to a group is there an automation for setting the start date for a set date for each group?

Appreciate any input

Thanks

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Keira,

You mean you want to set the start date of the item based on the group you’re moving it to?

[Keira_REZ (Keira Francis)]

Hi, yes that’s correct

[Keira_REZ (Keira Francis)]

Once I have dragged the item into a new group. I want the start date to update to the start date of that group.

I’m putting tasks into sprints (group). Each sprint has a different start date.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Natively you can’t because there is no automation that allows you to set the date of a column other to Today’s date.

But you can do it with a 3rd-party app called the Advanced Formula Booster.

Here is a demo. I assume the date is the title of the group, but it could be modified easily to read the date somewhere else.

All you need is a simple formula:

and an automation created inside the app (since the “When item is moved to {Group}” automation available in the Automation Center forces you to select a group. Our doesn’t).

Hope it helps.

[Keira_REZ (Keira Francis)]

Thanks for your help