Date 1 to change too date 2 when status changes

I am sending scheduled shipment to customers each at different intervals and the intervals may change. I have, last shipment and next shipment date columns , I have the next date calculate as last day + days shipped (a manually entered column) after we confirm the shipment was delivered
I want the last shipment date to change and reflect, the date that was in the Next shipment date.

Hi Darin! There is currently not an automation that would accomplish this.

That said, this may be possible using an app from our Marketplace, such as Autoboost. Specifically, this automation sounds similar to what you described:

Screenshot 2024-08-01 at 3.56.34 PM

Do note that autoboost was not developed by the monday.com. As such, we don’t have any control over its functionality. To learn more check out this article.

This worked thank you