task list connected to project sheet?

Hello,

We are working on an interdepartmental project where each department has created a project sheet listing and assigning all main tasks that team is responsible for. I would like people to then create individual task lists further breaking down all the things they need to do to complete the main task. is there a way to connect each task list to its corresponding row on the department project sheet?

TIA!

Find more posts tagged with

Sheets

Comments

Mike Wilday

Maybe you could create an IF formula that includes the link to the assignee's task list?

=IF(assignee1="Jim Halpert", "http://www.smartsheetlinktopersonaltasklist.com", IF(assignee1="Dwight Schrute", "http:///www.smartshetlinktopersonaltasklist.com", IF(assignee1="Kevin Malone", "http://www.smartsheetlinktopersonaltasklist.com")))

Let me know if you have any issues.

Mike Andreas

You may want to consider listing all the tasks on the main project tab, so that you can assign predecessors accordingly. I understand this can make for a complex sheet, but the benefit of having everything in one place could be worth it. You can then expand and collapse the plan to the level of detail that a conversation requires. You could then create shared filters for each department or team member showing their open tasks, etc.

JheramisC

this is an interesting fix! would you suggest doing a column separate from the "Task Name" column to include the hyperlink?

Mike Wilday

For dynamic effect you could... but you could also just update the formula in the first row that contains it and drag it down from the bottom-right corner to adjust it for the others.