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

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!