Show task of current active week on the Parent row
I need to show the task of the current active week on the Parent row. My sheet has a list of employees as parent rows and a couple of child rows. The Child rows show 'Current Week', 'Date', 'Task', 'Completed Hours' (columns). Every week they have a different task, tasks are manually selected from a dropdown-list. in the PARENT row I have a formula to show the current week they are at. I have another column were I need to show in the PARENT cell what task the employee is doing on the active week, this is my problem formula. They want to keep each CHILD row showing the information of that work week for future reference but want to be able to show management what the employees are doing that week without needing to check in the CHILD rows.
I tried using INDEX/MATCH with "Week" PARENT cell as the match column but could not figure it out. Unsure if there is another formula I could use for this.
Any ideas?
Best Answer
-
I created a column so tech can mark as complete and in progress and used that and the search criterion.
INDEX(CHILDREN(Task@row), MATCH("InProgress", CHILDREN([Task-Progress]@row), 0))
Thanks fo the help
Answers
-
Hi Marc1a,
Try this formula in Task cell of the parent row. Hope that helps.
=INDEX(CHILDREN(); MATCH(Week@row; CHILDREN(Week@row); 0))
Gia Thinh Technology - Smartsheet Solution Partner.
-
It did not, I get #UNPARSEABLE in the Task column and #BLOCKEDin the Week column.
-
I created a column so tech can mark as complete and in progress and used that and the search criterion.
INDEX(CHILDREN(Task@row), MATCH("InProgress", CHILDREN([Task-Progress]@row), 0))
Thanks fo the help
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!