How can I show the assignee of a parent task based on the current active sub task assignee?

Stephen Everiss

I would like a parent task to show the assignee based on the subtask that is active at a current time. Is this possible?

Ideally the task being active would be defined if the todays date is between start/finish dates.

For example:

Task 1 - Assignee = X
Task 1.1 - Assignee = X - In Progress
Task 1.2 - Assignee = Y - Not Started

Task 1 - Assignee = Y
Task 1.1 - Assignee = X - Not Started
Task 1.2 - Assignee = Y - In Progress

Gia Thinh

Just modify the formula a bit. Try this one:

=IFERROR(INDEX(CHILDREN(), MATCH("In Progress", CHILDREN(Status@row), 0)), "")

Gia Thinh

Hi @Stephen Everiss

Try this formula entered in the parent task 1 as the screenshot below. Hope it works for you.

=IFERROR(INDEX(CHILDREN(), MATCH("In Progress", CHILDREN(Status:Status), 0)), "")

Stephen Everiss

Hi @Gia Thinh Thank you for the response. It almost works - It shows the assignees for the first subtask but doesn't change based on the status.

In your example it would show GIA THINH Co. And won't change if I play with the statuses. I hope you can help.

Gia Thinh

Can you provide some screenshots?

Stephen Everiss

Sure, please let me know if you need more detail:

Gia Thinh

Just modify the formula a bit. Try this one:

=IFERROR(INDEX(CHILDREN(), MATCH("In Progress", CHILDREN(Status@row), 0)), "")

Stephen Everiss

That works perfectly. Thank you for your help.

Gia Thinh

Happy to help 🙂