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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!