I am trying to execute some logic that appears to not be available in automations or with any of the “apps” that I have attempted to install. Here’s what I am trying to do, any thoughts or suggestions will be greatly appreciated.
We have a parent Item X that gets a Start Date set at a certain point. There are 9 subitems that are created for 9 different tasks that all have unique due dates that are a certain number of days after the start date. So…
Parent Item: Start Date: Oct, 1
From there i have 9 date columns that are part of the parent item with dates set with a trigger for when the start date in the parent item is set. So Date1 = parent start date + 60 days, Date2 = parent start date +30, Date 3= parent start date +45 days, and so on.
I want to use these parent item dates and the due date for a subitem with a specific STATUS column. So that when the subitem is created with Date1 as it’s STATUS column, its due date will be the Date1 column from the parent.
I cannot for the life of me figure out how to make this work. What i need is an automation like: When subitem is created and subitem STATUS is something, set DATE in subitem to DATE COLUMN in parent item.
I have tried many ways of making this work, no dates in parent, push dates etc but I cannot figure it out! Help!
Thanks!