Parent Task Due Date

[Danny_Pettiona]

Hey Coda Team,

So I have a Project tracker and I want the parent task’s due date to be dependent on the child tasks.

See screenshot below:

1. This is a formula column that determines whether it is a parent, child1, child2, child3.
2. This is the due date of the child task.
3. This is where I want the parent task due date to live (based on the MAX of the child tasks below it).

I currently have this formula, but it’s not working:

1. This is a formula column that returns 0 if the row is a parent row.
2. This is RANK rounded down to the whole number. It basically shows what child tasks relate to what parent task.

Any ideas what I might be doing wrong?

Ideally it should look like this.

Thanks all

[Danny_Pettiona]

Hey all, I found a solution for this by using a lookup table.

Then in the main table:

Thanks!