Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
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!
Comments
-
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.
-
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.
-
this is an interesting fix! would you suggest doing a column separate from the "Task Name" column to include the hyperlink?
-
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.
