Need some help from Workflow Wizards

[ImNerdy]

Ok! So I want to create a workflow that automatically updates a date property when another date property is known or updated.

Below is a picture so I can explain what I want to do.

1. The Back Cover to Designer date property is known. This a date that is set in stone and it’s one that is uploaded when I import the new books.
2. Once I add or update this Book (custom object) I want the Back Cover Due to Sharon date property to be automatically updated to be two weeks prior to the Back Cover to Designer date.
   1. In this example, the back cover is due to the designer on 2/11/2025. So the date for the book to be due to Sharon would be 1/28/2025.
3. And then I want the Back Cover Due to Author property date to be automatically changed to be two weeks prior to the Sharon date or four weeks prior to the Designer date.
   1. In this exampe the Due to Author date would be 1/14/2025
4. And I need this all to happen regardless of how far in the future the property date is. So I can’t have it wait until the date of an event to set the property.

So, wizards? Any magic you can sprinkle on this to help?
Thank you!

[franksteiner79]

Hi @ImNerdy

I’d do this via calculated properties instead of workflows, it’s an easier approach IMHO.

Frank

[ImNerdy]

Oh my gosh. I never even knew this was a thing. You’re a lifesaver!