Hi… we have a process for creating content where we need an overall due date set on the item, and then other column dates for different points in the process to be assigned a due date working backwards from the overall due date.
Ex: Blog is due to be published on xx/xx/xx
We need the formatting done 3 days before publish date
Graphics need to be done 5 days before publish date
Final copy done 7 days before publish date
I have found where I can have an automation that when one date is changed, it will adjust/set another date by that first date + the number in a number column. I can manually enter a negative number (-3) and when the Publish Date is changed, then another date will be set to Publish Date + Number = xx/xx/xx - 3 days
That is great - buuuuut I have multiple columns and I have to MANUALLY enter in the negative numbers for each new item I create!! The automation to set a number when a new item is created will only allow POSITIVE numbers
Is there another workaround to get this working right? I’ve been looking and looking through the automations, but the Push Date only works going forward, not backwards!
Your help is appreciated!!!