Return task description for next task due
Hi,
I'm trying to return the task description for the next task due on a project plan. Right now I'm using
=JOIN(COLLECT({Project Plan - EOL Asset Enterprise Range 1}, {Project Plan - EOL Asset Enterprise Range 4}, @cell < 1, {Project Plan - EOL Asset Enterprise Range 6}, @cell = 1, {Project Plan - EOL Asset Enterprise Range 7}, >=TODAY(7)), ", ")
And it's giving me all tasks due in the next 7 days, which makes sense. I would ultimately like it to tell me "if a task if the child of a phase, what is the task name/description for the next due task?"
My ranges are as follows:
Project Plan - EOL Asset Enterprise Range 1 - Task name/description
Project Plan - EOL Asset Enterprise Range 4 - % complete
Project Plan - EOL Asset Enterprise Range 6 - Phase #
Project Plan - EOL Asset Enterprise Range 7 - Task end date
I have tried to find this in the community but nothing seems to work.
Any help is much appreciated.
Answers
-
Can't use parent/children references inside of a collect, you need a helper column in the original sheet.
=iferror(parent({Project Plan - EOL Asset Enterprise Range 1 - Task name/description}),"")
Change the other column reference to the applicable local reference, and make it a column formula. Then you can reference the helper instead of the task column
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!