Parent Task Due Date

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.

CleanShot 2022-02-08 at 07.18.54

CleanShot 2022-02-08 at 07.21.56

Any ideas what I might be doing wrong?

Ideally it should look like this.

Thanks all

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

Then in the main table:


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.