Automatically set due dates based on timeline

I would LOVE to be able to automatically set a subitem due date by using a timeline column’s end date. Additionally, I am trying to get the last subitem’s due date to roll up to the parent item. I have figured out how to have the parent item (“Project Timeline” in my example) show the subitems start to end timeline.

In my attached example, this is what I’m trying to accomplish:

  • Have “Task Due By” date auto-populate with the “Task Timeline” end date for that line

  • Have Parent Item “Due Date” auto-populate the last subitem’s due date or last date in subitems timeline