I have pretty unique use case it seems as I have searched and really can’t find a solution.
Essentially what I want to do is have a sub item date be automated based on the date in the main column. The main date is not a TODAY date and may be several months ahead in time for each item, so using a date/push doesn’t work as the date is different for each item.
Has anyone encounter this? If so what was your solution. Open to any and all ideas! 
Example:
That’s a tricky one since most built-in automations are designed around relative triggers like “today” or “X days after.” If the sub-item always needs to mirror or offset the main item’s date, a formula column or dependency setup might work better than automation. You could also explore connecting the two with a custom script or API call if your platform allows—sometimes that’s the cleanest way to keep dates in sync.
Hello,
Here is how you can do it with workflows or combo-effort with automations & ai :
Here is a sample board. You will need to have all of these columns.
Item Level: Due Date, Status column (change/no change)
Subitem Level: Due Date, Custom AI column, Connect Board (connected to this board), Mirror Parent Due Date, Mirror Status column, Status column (change/no change)
IMPORTANT NOTE: Every time you add a new subitem, you will need to manually connect it to the parent item. Unfortunately, there is no automation to automatically connect subitem to parent item.
