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
-
Just modify the formula a bit. Try this one:
=IFERROR(INDEX(CHILDREN(), MATCH("In Progress", CHILDREN(Status@row), 0)), "")
Gia Thinh Technology - Smartsheet Solution Partner.
Answers
-
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)), "")
Gia Thinh Technology - Smartsheet Solution Partner.
-
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. -
Can you provide some screenshots?
Gia Thinh Technology - Smartsheet Solution Partner.
-
Sure, please let me know if you need more detail:
-
Just modify the formula a bit. Try this one:
=IFERROR(INDEX(CHILDREN(), MATCH("In Progress", CHILDREN(Status@row), 0)), "")
Gia Thinh Technology - Smartsheet Solution Partner.
-
That works perfectly. Thank you for your help.
-
Happy to help 🙂
Gia Thinh Technology - Smartsheet Solution Partner.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!